How to convert an elapsed time in minutes to Days hours and minute

I would like to be able to convert a large number of minutes into days hours
and minutes (i.e 1550 minute= 1 day 1 hour 50 minutes).

Also I would to know how to calculate what time would 1 day 1 hour and 50
minutes be from a certian starting point.

=A1/1440

custom format as d hh:mm

If you use real excel times then put 25:50 in a cell then just add it to
whatever time you start from



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Time Tracker" <Time [email protected]> wrote in message
news:[email protected]...
>I would like to be able to convert a large number of minutes into days
>hours
> and minutes (i.e 1550 minute= 1 day 1 hour 50 minutes).
>
> Also I would to know how to calculate what time would 1 day 1 hour and 50
> minutes be from a certian starting point.