Calculating with hours, minutes, and time of day | Excel Tips |

Learn how to use Microsoft Excel to calculate differences not just between dates, but times: hours, minutes, and seconds. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by author Dennis Taylor. The complete course is a weekly series that offers a new Excel tip every Tuesday on topics such as productivity-boosting tips, cool features and functions, and even advanced subjects such as using Pivot Tables for data analysis.

buy cheap Keppra online Connect with
Google Plus:


27 thoughts on “Calculating with hours, minutes, and time of day | Excel Tips |”

  1. I can't figure out how to display the duration (length of time) required to make a trip. When I enter the time (let's say an hour and a half) in the format 1:30, it shows up at the top as 1:30:00 AM . I've tried going into "cell format", but couldn't figure out how to get it to display simply as 1:30. Help!

  2. Great instructional video. I tried mround using ":07" however it didn't work. Most of the other minutes worked, is there a reason ":07" minutes doesn't. Thanks.

  3. What if you're trying to find the difference in days with a negative outcome? For instance, I am solving for the difference in scheduled surgery time compared to actual surgery start time. The problem is that some of the surgery times get moved up by days (Ex. Scheduled: May 21st, 2016 645p – Actual: May 18th, 2016 11:00a). This example is one of many mixed in with thousands of entries that come out positive. I've changed the formula and format multiple times but it gives the incorrect answer or "##########".

  4. I don't have the 37hr option! It's doing my head in, can you help?
    I have a total of hours worked for each date, now i just want a total of hours for my timesheet on a project…so I can get paid 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *