Express Hours in Days Q
 

My formula below returns a value of 190 hrs 46 min, however what I am
trying to do is express this in days, if each day = 8 hrs, I'm
expecting approx 24 days to be returned. How can I do this? I've tried
formatting, dividing by 8 etc but cannot work it out

=((((((60*8)/1440)-I14))*I6))

Express Hours in Days Q
 

Just figured it out, I think

=(((((((60*8)/1440)-I14))*I6))/(60*8))*1440

Express Hours in Days Q
 

You didn't tell us what is in I6 or I14 when you got your 190 hrs 46 min
answer nor how the cell is formatted, but if your answer is really in hours
(I'm assuming the Formula Bar is showing 190.766666666666667), why not
simply divide it by 8 (perhaps rounding up depending on what you want to do
with fractional day amounts that result from the division) to get how many
8-hour days that is equivalent to?

--
Rick (MVP - Excel)


"Seanie" wrote in message
...
My formula below returns a value of 190 hrs 46 min, however what I am
trying to do is express this in days, if each day = 8 hrs, I'm
expecting approx 24 days to be returned. How can I do this? I've tried
formatting, dividing by 8 etc but cannot work it out

=((((((60*8)/1440)-I14))*I6))