Elapse date and time
 

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.

Elapse date and time
 

Subtract and custom format results as [hh]:mm

--


Regards,


Peo Sjoblom


"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.

Elapse date and time
 

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

"jbrag" wrote:

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.

Elapse date and time
 

=(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.