calculate elapsed time between dates and times

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
 
G

Gary''s Student

--
Gary''s Student
=(A2+B2)-(C2+D2)
and the trick is to format the cell as [h]:mm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top