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

[Guest]

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.

 

[Peo Sjoblom]

=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