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.