date/time formula
 

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 and 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 to show in and then custom format that cell to [hh]:mm

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

Hope that helps.

S.