Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
To keep it short and simple: I have 4220 lbs of grain and I can only unload 2000 lbs a day. I divide the number and end up with 2,1100 work days. How is it possible to have excel write the days, hours and minutes as I can only get it to write the hours and minutes used. 4220/2000 = 2,11 days = 02h:38m:24s. The time spend is the same if I only write ,11.. Is it even possible for Excel to do this? Or am I supposed to just write the days in myself and let excel do the rest??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting days, hours and minutes to minutes | New Users to Excel | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Formula for minutes to days:hours:minutes | Excel Discussion (Misc queries) |