| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Difference Hours, Minutes
I've searched and can't find a formula for this scenario. I need to
calculate the difference between two dates and need the results displayed as listed next to Duration. If the calculation results in more than 24 hours, I'd like it to display something like 25H 13M. Is this possible? EventStart 8/11/09 15:40 EventEnd 8/11/09 23:56 Duration 8H 16M Thanks! Jim |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Difference Hours, Minutes
Jim
Simply subtract earlier date from later one and format as [h]"H "mm"M" Mike "Jim" wrote: I've searched and can't find a formula for this scenario. I need to calculate the difference between two dates and need the results displayed as listed next to Duration. If the calculation results in more than 24 hours, I'd like it to display something like 25H 13M. Is this possible? EventStart 8/11/09 15:40 EventEnd 8/11/09 23:56 Duration 8H 16M Thanks! Jim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Difference Hours, Minutes
Thank you, exactly what I needed!
"Mike H" wrote: Jim Simply subtract earlier date from later one and format as [h]"H "mm"M" Mike "Jim" wrote: I've searched and can't find a formula for this scenario. I need to calculate the difference between two dates and need the results displayed as listed next to Duration. If the calculation results in more than 24 hours, I'd like it to display something like 25H 13M. Is this possible? EventStart 8/11/09 15:40 EventEnd 8/11/09 23:56 Duration 8H 16M Thanks! Jim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference in Days, Hours, Minutes and Seconds | Excel Discussion (Misc queries) | |||
| Date Difference in ONLY minutes | Excel Discussion (Misc queries) | |||
| Difference of time in hours or minutes | Excel Discussion (Misc queries) | |||
| Hours and minutes display as date in formula box | Excel Discussion (Misc queries) | |||
| Difference of date & time in minutes | Excel Worksheet Functions | |||
Hybrid Mode
