Working with Time in Microsoft Excel | Time Functions and Conversion

Do you need to add or subtract time in Excel? Some time calculations are easy, but depending on how the time is entered, you may need to use the TIME function or formula to add or subtract time. For example, if you have 9am in B2, and in cell C2, you have 3, for three hours, you can't add them with B2+C2 and get the correct answer without the TIME function.

**********
Chapters:
**********
00:00 Intro to chapters
01:00 TIME function
02:56 Add two-time numbers
4:10 Add time format and number together
5:25 Subtract time
6:20 Total time over 24 hours
7:30 Subtract time over midnight
8:20 Time as a decimal

Excel file used in this video

Blog post

**********
TIME Function
**********
TIME(hour, minute, second)
The TIME function syntax has the following arguments:

Hour Required. A number from 0 (zero) to 32767 representing the hour. Any value greater than 23 will be divided by 24, and the remainder will be treated as the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM.

Minute Required. A number from 0 to 32767 representing the minute. Any value greater than 59 will be converted to hours and minutes. For example, TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.

Second Required. A number from 0 to 32767 representing the second. Any value greater than 59 will be converted to hours, minutes, and seconds. For example, TIME(0,0,2000) = TIME(0,33,22) = .023148 or 12:33:20 AM
=B2+TIME(3,0,0)
If B2 contains 9am, the function will return at 12pm. It adds, 3 hours to 9am.

**********
Websites:
**********

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[sgorjski]

Thank you! You just saved me SO much time! I needed to show an arrival time 30 minutes before a scheduled time and I wasn't sure how to make that happen - you made it so simple! Thanks again!

[Dwavard]

Fantastic - the tip to explaining how to add up time v. helpful :-)

[pencilpainters]

Thank you….i just started with Excel….i needed this lesson . 👍

[sanchezdora]

Thank you Chris! easy and clear explain!

[Sassyuu]

Thanks so much…you are the only one that I understand.

[ibrahim]

thanks you, you just saved me So much time, bless you sir.

[husamghaffari]

Thanks a lot Sir it solved my problem with in few seconds as your video was on point and not wasting any time

[aymantaher]

Man, u're a lifesaver.
God bless you <3

[ahmedy.albanna]

Very well explained, U R exceptional Chris.

[chukwudikeofodum]

I have time written as 00:30:09 in my rows, but appears as 12:30:09 on the formula bar. How do i fix this?

This appears normally on my personal system, but differently as explained above on my work desktop

[billjuss]

Chris M, Love your Video: Thanks for showing some Tricks. Current Time = " Ctl Shift ; " THANK YOU!!!

[Project.]

Can Excel calculate the duration of time over many days? For example, I start my well pump on June 1 at 10 AM and turn it off on June 7 at 3PM. Is there a formula that gives me the amount of hours and minutes the pump was on?

[sukidve]

Hey Chris. I want to add cumulative hours in Excel. I am able to do it with [h] Format upto 4 digit in hours. What to do for more than that.
Like I have 30000:20 hours and minutes and would like to add say another 100 hours to this.

[firetrucker]

What formula can I use to determine if a start time/end time is in AM or PM if it just shows the military time without the AM/PM indicator?

[meniiix]

Hi Chris, new fan here. I'm trying to impute hours and minutes to create a graph of how long I spend time on social media. If I put in 1:45 in a cell it keeps trying to read it as 1:45 am. How can I keep hours and minutes without realating to the time of day.

[akinsamuel]

Hi Chris' - I've seen this solution but I sill cant get it to work. I assume it may be a problem with the Version of Excel I'm using being the Chrome in house Google version? Adding up a list of times with a total at the end that doesn't recycle the clock continues to elude me...

[ubaidillahmuhammad]

nice and good job. but please put all excel practiced files in the description

[badger]

Great video! How do you subtract 15 minutes from 1:02:00 am? Thanks

[maidenfuller]

Hi, very smart. How can I display a result in a cell that has a formula displaying time, to display minutes?

[ubaidillahmuhammad]

nice and good job. but please put all excel practiced files in the description....