Show as Hours and Minutes

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

F14 has the final results for the amount of time. It currently shows:
Example: 38, 72 etc.... I'd like for it to show 0 hours 38 minutes, 1
hour 12 minutes etc...
Thanks in advance
 
If you mean you want to see: 00:38:00 or 01:12:00
(real times)

Then you could use a formula in an adjacent cell:
=f14/24/60

But make sure you format this cell to look like a time.
 
Back
Top