Formula for minutes to days:hours:minutes

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

Hi!

If the minutes are in A3,

set B3 =INT(A3/1440) to give the days
set C3 =INT((A3-B3*1440)/60) to give the hours
set D3 =A3-1440*B3-60*C3 to give the minutes.

If you want to give the result as a composite days/hours/minutes result then
set E3 =B3&" days " &C3 & " hours " &D3 &" mins".

Alf

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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