Calculate Time Difference

How can I extract the time difference between two Cells
Like

9/2/2011 10:35 9/2/2011 1:35

I need to show the time and day, but on the third cell say A3 it shows the time difference !

Assuming that is 10:25 AM and 1:35 PM

and they are in A1 and B1, respectively, try:

=(B1-A1)*24

gives number of hours difference.

Here is the exact format I have it in

9/2/2011 10:35 9/2/2011 1:35

Date and Time

I tried your formula, result is 9

Do i need to keep the date in a separate cell?

Will the day always be the same in A1 and A2? If not, which day do you want to show in your result? Okay, saying that A1 < A2, try with cell formatted the same as A1 and A2;

=INT(A2) + (A2-A1)
Does that work for you? You're mixing up dates and time (as in on a clock) with time as a difference (hours and minutes) so not sure why you still want the day in your result.

no dates don't need to be in different cells... but if you click on those cells, what do you see for each in the Formula Bar up top?

I'll take that back.

This 9/2/2011 1:35 was at AM

When I switched it to PM it gave me 3 hours, which is correct.

Thanks

Don't forget to please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I 'll take that back.....

Not 100% working for me.

Down Time Log
Ticket # Created Deploy Down For in hours

ENRQIII-169 8/31/2011 12:48 9/1/2011 18:37 PM #VALUE! =(E5-D5)*24
ENRQIII-170 8/31/2011 15:54 9/1/2011 17:30 25.60
ENRQIII-171 9/1/2011 13:10 9/1/2011 14:10 1.00
ENRQIII-172 9/1/2011 14:45 9/1/2011 16:50 2.08
ENRQIII-175 9/2/2011 8:00 9/2/2011 10:30 2.50
9/2/2011 10:35 9/2/2011 13:35 3.00

#VALUE!

I am trying to calculate the time difference , as you can see the first one is not showing the correct out put !

The #VALUE means to me you have a text entry in either D or E or both. Double check those

The 18:37 PM is being seen as text. Remove the PM (it's redundent)

Perfect,

You were right

Down Time Log
Ticket # Created Time Compl. / Deploy Time Down For in hours

ENRQIII-169 8/31/2011 12:48 9/1/2011 17:30 28.70

Now is it possible to get the total only between business hours. Say from 8:30AM to 5:30PM?

Our very own daddylonglegs has a post here that should help:

http://www.ozgrid.com/forum/showthre...t=87732&page=1