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

[KathyS]

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.

 

[Bob Phillips]

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