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" <KathyS@discussions.microsoft.com> wrote in message
news:96BE717F-E273-4817-8046-CC28DD5A5D8B@microsoft.com...
> 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.