Quote:
Originally Posted by 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 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.