Elapse date and time

[jbrag]

I have four columns start date, start time, end date, end time. How do I
calculate the elapsed hours if the start date and end date are several days
apart? I found the formula if it is one day but not several. i.e. A1 Start
Date 1/2/2008 B1 Start Time 2:30 PM, C1 End Date 1/6/2008, D1 End Time 4:30 PM
I need to know how many hours elapsed.

 

[Peo Sjoblom]

Subtract and custom format results as [hh]:mm

--


Regards,


Peo Sjoblom

 

[jbrag]

the answer is =d1-b1+(c1-a1)

 

[David Biddulph]

=(C1+D1)-(A1+B1) and format as [h]:mm