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.