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)



"QueenCutieT" wrote in message
...
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 (the number of minutes in a day). Use a custom format of
dd:hh:mm

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"QueenCutieT" wrote in message
...
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