I have been trying to calculate the number of hours between two dates and times for a total of hh:mm.
From 9/15/12 9:00 am thru 9/20/12 6:37 pm as an example.
Can anyone solve this delima?
Thanks!
LESTER A. WOOD
CHESTERFIELD, MO. 63005
I have been trying to calculate the number of hours between two dates and times for a total of hh:mm.
From 9/15/12 9:00 am thru 9/20/12 6:37 pm as an example.
Can anyone solve this delima?
Thanks!
LESTER A. WOOD
CHESTERFIELD, MO. 63005
How bout this
A1 = 9/15/12 9:00 am
B1 = 9/20/12 6:37 PM
129 hours 37 minutes
Formula:Please Login or Register to view this content.
Or format the cell that has the formula to [h]:mm
Formula:Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks