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://andysproshop.com/800-honor-roll/ 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.

source site Connect with lynda.com:
Facebook: http://bit.ly/fbldc
Twitter: http://bit.ly/ldctw
Google Plus: http://bit.ly/gplusldc
LinkedIn: http://bit.ly/linkldc

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!

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. please help me about this and send me an email about this matter. I will be very thank full about your help.

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.

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

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 🙁

33:18:00 (33 min 18 secs) 45:02:00 (45 min 2 secs) 01:13:11 (1 hour 13 min 11 secs) 01:53:59 (1 hour 53 min 59 secs) 01:31:16 (1 hour 31 min 16 secs) 37:01:00 (37 min 1 sec) how can we add the above in excel please help urgent

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

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

Please explain, "double click, you've got the calculations on the others." Double clicking does nothing for me. Please help. Thanks.

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

sorry I have one question to change from 00:00 to 24:00.

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

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!

Thanks a lot…

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

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?

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.

please help me about this and send me an email about this matter. I will be very thank full about your help.

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?

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.

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

Thank you very much , it helped me 🙂

THANK YOU SO MUCH FOR MAKING THIS VIDEO!!!!!!!!!!!!

thanks

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

nice

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

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?

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 🙁

Nice… Thank you!

33:18:00 (33 min 18 secs)

45:02:00 (45 min 2 secs)

01:13:11 (1 hour 13 min 11 secs)

01:53:59 (1 hour 53 min 59 secs)

01:31:16 (1 hour 31 min 16 secs)

37:01:00 (37 min 1 sec)

how can we add the above in excel

please help urgent

Thank you!!!

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

Wonderful Video !

Million Thanks !