Formula for minutes to days:hours:minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report out of another system that shows ventilator time in minutes
and the end user would like to see it in days:hours:minutes. It's difficult
to put your head around how long 7171 minutes is.

Thank You
 
Divide by 1440 and use a custom format [h]:mm
will get you the time in hours

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Divide by 1440 (the number of minutes in a day). Use a custom format of
dd:hh:mm
 
You must log in or register to reply here.

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

Similar Threads

Report a given number in days:hours:minutes ? 2
Converting work hours to day/hours/minutes 3
Display Total Minutes in Days:Hours:Minutes 5
Difference between dates, but a bit more complicated 2
calculating duration/converting hours to days, etc 3
Creating Formulas In Excel To Calculate Time Intervals 1
Minute Formulas 2
Formula for 20 minute meetings 4

Back
Top