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

"jbrag" wrote in message
...
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.