View Single Post
  #1   Report Post  
KathyS
 
Posts: n/a
Default 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.