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