| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date/time Duration
How do I make a formula in excel which will allow me to calculate the
duration in hours and minutes of two different dates and times? IE: 1/1/05 01:00 to 1/2/05 01:00 is 24 hours and 0 minutes. |
|
#2
|
|||
|
|||
|
Just subtract the lesser from the larger and format as [hh]:mm
-- HTH Bob Phillips "zjay" wrote in message ... How do I make a formula in excel which will allow me to calculate the duration in hours and minutes of two different dates and times? IE: 1/1/05 01:00 to 1/2/05 01:00 is 24 hours and 0 minutes. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date/time range based calculations | Excel Discussion (Misc queries) | |||
| convert duration (hr:mn:sec) in to equivalent sec | Excel Discussion (Misc queries) | |||
| Duration | Excel Discussion (Misc queries) | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
| How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. | Excel Worksheet Functions | |||
Linear Mode
