Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with duration data
I am working with process duration data, and typically collect it in hour,
minutes and seconds. In some cases, a process step might take over 600 hours (600:14:30). It seems that as long as I keep everything in a [h]:mm:ss format (or the 37:30:55 preset) I can sum all the hours from various step whilst maintaining accuracy. What I was wondering if there is a format that converts to days, hour, minutes and seconds in the same manner while maintaining the ability to perform math functions (i.e. addition, subtraction). Finally, is there way to convert that number to working days, minutes, hours, and seconds. Thanks in advance, your answer will make my presentation more boss friendly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duration | Excel Worksheet Functions | |||
format for duration | Excel Discussion (Misc queries) | |||
fx duration | Excel Worksheet Functions | |||
Duration | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) |