| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Date AND Time Differences
 Within 4 columns, I have a series of: Start Dates / Start Times / End Dates / End Times I need to create a formula which will give me the sum total of the difference between the data sets. For example, the time difference between 8am on the 20th March and 1pm on the 21st March is 29 hours OR 1 day and 5 hours. I need a formula which will calculate this for me. I have driven the Paper Slide help function crazy by asking in numerous ways how to do this and I've also searched the forums as well as asking my resident Excel guy at work, but I cannot locate a solution.... Can anyone help ?? Regards, Lea777 -- Lea777 ------------------------------------------------------------------------ Lea777's Profile: http://www.excelforum.com/member.php...o&userid=32692 View this thread: http://www.excelforum.com/showthread...hreadid=525103 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| calculating the time between one date and another | Excel Discussion (Misc queries) | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| calculating date time ranges | Excel Worksheet Functions | |||
Threaded Mode
