| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate elapsed time between dates and times
i have a spreadsheet where i want to calculate elapsed time in hours and
minutes between two dates. dates and times are in separate cells eg A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00 The elapsed time should be 49 hours 30 minutes is there a formula to calculate elapsed time to give an hour and minute value? any help would be gratefully received jenna |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate elapsed time between dates and times
=(C2+D2)-(A2+B2)
FormatCellsNumberCustom, [h]:mm -- Kind regards, Niek Otten "Jenna" wrote in message ... i have a spreadsheet where i want to calculate elapsed time in hours and minutes between two dates. dates and times are in separate cells eg A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00 The elapsed time should be 49 hours 30 minutes is there a formula to calculate elapsed time to give an hour and minute value? any help would be gratefully received jenna |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate elapsed time between dates and times
-- Gary''s Student =(A2+B2)-(C2+D2) and the trick is to format the cell as [h]:mm "Jenna" wrote: i have a spreadsheet where i want to calculate elapsed time in hours and minutes between two dates. dates and times are in separate cells eg A2: 01/01/2006 B2:09:30 C2:03/01/2006 D2:11:00 The elapsed time should be 49 hours 30 minutes is there a formula to calculate elapsed time to give an hour and minute value? any help would be gratefully received jenna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Difference between 2 times and dates | Excel Worksheet Functions | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Linear Mode
