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.
|