date/time formula

B

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
 
S

Spencer101

briandel7;1601090 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top