How to get the difference in hours of 2 dates with this format "1/15/2013 2:06:56 PM"

If your two dates are in B2 and B3, the following formula should work:

Formula:

Please Login or Register  to view this content.

Hi, and welcome to the forum

=(B1-A1)*24

You could try this:

If 1st date is in A1, and second date is in A2:

=(A2-A1)*24

- Moo

Hi,

Are you sure those dates are date NUMBERS albeit formatted as mm/dd/yyyy hh:mm:ss.

And have you formatted the cell in which you're putting the formula as a number not date?

If so I suggest you upload your workbook, or at least the relevant bit of it.

Hi

1/16/2013 9:55:43 AM-1/16/2013 9:55:23 AM

Assuming the red Date/Time is in A1 and Blue Date/Time is in A2
Subtract smaller Date/Time from the larger Date/Time

Formula:

Please Login or Register  to view this content.

And format cells as hh:mm:ss