Formula for minutes to days:hours:minutes

Q

QueenCutieT

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
 
P

Peo Sjoblom

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)
 
F

Fred Smith

Divide by 1440 (the number of minutes in a day). Use a custom format of
dd:hh:mm
 
Top