I have the formula =IF(E17>=480,(E17/480),"Under 8 Hours")
which is meant to compute any value above 480, which is 8hrs in minutes.
But it's not working as it should. It's executing the formula even for values below 480. I've formatted the result cell as d
"day(s)", h
"hour(s)" and m
"minute(s)" while the source cell (E17) is in minutes, m
.
E17
?=IF(HOUR(E17)>7;INT(E17)&" day(s), "&TEXT(E17;"H"" hour(s) and ""M"" minute(s)""");"Under 8 Hours")
?E7
with=VALUE(E17)
. I'm sure that will shed a lot of light, as that is what the if condition is working with as well.