Show a time from one calculated cell as a decimal in another cell.
 

I have a SUM OF cells that are formatted as time [add the hours worked for a
dozen individuals] 135:24. One hundred thirty five hours and 24 minutes. I
would like to have another cell look at that number and show it as 135.24 in
another cell.
I don't want the decimal version of the 135:24 [5.81]. I want to cell to
contain the value of 135.24.
This is pretty urgent - so if anyone can help that would be GREAT!
Thank you.

Kathy,

Sure you mean 135:24 - 135.24, not 135.4? assuming so,. then

=INT(H1*24)+MOD(H1*24,1)*0.6

make sure it is formatted as decimal not time

--
HTH

Bob Phillips

"KathyS" wrote in message
...
I have a SUM OF cells that are formatted as time [add the hours worked for
a
dozen individuals] 135:24. One hundred thirty five hours and 24 minutes.
I
would like to have another cell look at that number and show it as 135.24
in
another cell.
I don't want the decimal version of the 135:24 [5.81]. I want to cell to
contain the value of 135.24.
This is pretty urgent - so if anyone can help that would be GREAT!
Thank you.