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
|