Show as Hours and Minutes

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top