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
|