How can I obtain the difference in hours of 2 dates with this format "1/15/2013 2:06:56 PM" (without the quotes).
Thanks in advance
Alan
How can I obtain the difference in hours of 2 dates with this format "1/15/2013 2:06:56 PM" (without the quotes).
Thanks in advance
Alan
If your two dates are in B2 and B3, the following formula should work:
Formula:Please Login or Register to view this content.
Please click the * icon below if I have helped.
Hi, and welcome to the forum
=(B1-A1)*24
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
You could try this:
If 1st date is in A1, and second date is in A2:
=(A2-A1)*24
- Moo
Last edited by Moo the Dog; 01-15-2013 at 06:47 PM. Reason: Looks like it's 'Slow-Poke Tuesday' for me. :)
Still with the issue:
=1/16/2013 9:55:43 AM-1/16/2013 9:55:23 AM
Excel does not recognize it... I get an error always
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
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks