Time difference calculations in Excel

February 14, 2012 at 00:53:40
Specs: Windows XP
how do i calculate difference in time using a 24 hour clock

I input a time in column one of 22:46:00 and in a second column input time of 01:03:00 and need to calculate the difference in hours and minutes.

I have tried a text function and an If function but something keeps going wrong.

See More: Time difference calculations in Excel

Report •

February 14, 2012 at 17:21:00
Ok, first of all make sure that the cells containing the data are formatted in time format mirroring what you have showing in your question (specifically, HH:MM:SS).

Next, use this formula to calculate out the times:


What this will do is check to see if the second number (01:03:00 in your example) is less than the first number (22:46:00 in your example). If it is, then it will add a 1 to it, essentially adding a day to the second number and allowing it to correctly calculate overnight time windows.

Please let me know if you have any questions or need more assistance.

IT Desktop & Network Consultant - MOS Master Certified, MCP, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +


Report •

February 14, 2012 at 22:00:17
thank you so much. I would not have thought of adding a day, but this makes so much sense.

Report •

February 14, 2012 at 23:15:48
FYI you can use =text(Cell,Format) To Assign Complete Format in to the value

Report •

Related Solutions

Ask Question