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 |
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 |
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 |
All times are GMT +1. The time now is 05:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com