Thread
:
How to convert an elapsed time in minutes to Days hours and minute
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
Posts: n/a
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.
Reply With Quote