date/time formula

[briandel7]

I need help?
I have 4 pieces of individual data.
A1= date taken (2/6/12)
B1= time taken (07:44)
C1= on site date (3/6/12)
D1= On site time (13:02)

How do i calculate the hours in between the time order was taken an
time on site. And yes the dates are correct, the number should be high

 

[Spencer101]

I need help?
I have 4 pieces of individual data.
A1= date taken (2/6/12)
B1= time taken (07:44)
C1= on site date (3/6/12)
D1= On site time (13:02)

How do i calculate the hours in between the time order was taken an
time on site. And yes the dates are correct, the number should be high.

Hi,

Try entering *=(C1-A1)+(D1-B1)* into the cell you wish the result t
show in and then custom format that cell to *[hh]:mm*

Make sure you include the square brackets to show the correct number o
hours rather than it starting from zero again if it's over 24 hrs.

Hope that helps.

S