# Calculating with hours, minutes, and time of day | Excel Tips | lynda.com

Learn how to use Microsoft Excel to calculate differences not just between dates, but times: hours, minutes, and seconds. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=5uqkrzkEXCU&utm_medium=social&utm_source=youtube-earned

http://theplumeapp.com/blog This tutorial is from the Excel Tips Weekly series presented by lynda.com 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 lynda.com:

source

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

1. Never ever go with ADP, its the most corrupt Payroll company out there.

2. can you help with this problem, please, how I can do this in excel, hrs 6:00x\$9.50+\$30=\$87/6 hrs=\$14.50 per hrs

4. I only watched the first 3 minutes,

You addressed exactly what I was running up against, quickly showed the solution and got a thumbs up! Great work

5. Sir, There are very few videos on TIME function. Accordingly to me; by far; this one is the BEST. Thanks for sharing.

6. 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!

7. Hahaha now I know [h] fixes it. Thanks a bunch

8. I have the same setup of m/d/y h:m:s am/pm and the formula =c2-b2 returns #VALUE. So confused, what simple thing am I missing?

9. Thanx a lot but i have a problem is this i have substract day by day hours and minuts but i cant to sum all substracted working hours
12:40
10:15
12:20
11:20
10:35
11:40
12:20
12:40

Total=??????? i cant calculate these hours in total hours and minutes.

10. what if column a and b have same time and i want to change the in column b by 1 sec so times do not match?

11. 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.

12. An excellant, very clear and easy to understand video. Thank you for your time to produce it.

13. 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 "##########".

14. Very Clearly explained .Practically i did ,i got the answers. Thank you so much. God Bless you.

15. I want millisecond format and I don't have hh:mm:ss.000 in my excel 2013 format window. Is there any add-in for that?

16. 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 🙁

17. How do you calculate business days, hours and minutes between two time stamps