|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 24th, 2005, 10:51 AM
|
|||
|
|||
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
May 24th, 2005, 10:58 AM
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Date/time range based calculations | jim314 | General Discussion | 1 | April 28th, 2005 07:21 PM |
| "Style Emphasis" using the "Until Next Click" Duration | Brandon | Powerpoint | 1 | February 9th, 2005 12:25 PM |
| Total process duration | V. Katz | Visio | 3 | August 10th, 2004 06:27 AM |
| calc hours from date/time to date/time | Shardon | Worksheet Functions | 1 | November 9th, 2003 11:45 PM |
Linear Mode
