J
Jenna
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
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