Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
i need to convert seconds (ie: 17288.35111) into days, hours, min | Excel Discussion (Misc queries) | |||
Timecards, hours & minutes | Excel Worksheet Functions |