View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How to convert an elapsed time in minutes to Days hours and minute

=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 wrote in message
...
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.