How to Sum Time in Excel

[@tristonstephens5728]

You have the best tutorials about excel in the world; everytime I watch one of your videos the result is tremendous. I perused many other tutorial and none came even close to yours

[@prairiehorse6168]

Is there a way to convert the summed value into number format? For e.g., 48:30 to 48.50? This would be incredibly helpful when multiplying with hourly rate to get wages. Thanks.

[@ibueno90]

Thank you so much! I was stuck for days and couldn't figure out how to properly sum hours, this is fantastic!

[@TheLostZone]

How do I add pure time together? For example I ran for 1:03:26:06 today and 1:15:37:13 how do I get the sheet to add the time together and know that the seconds, min and hours are added correctly?

[@computerliteracy2023]

Very helpful, you are my teacher!

[@sohel_chhipa]

Thanks you for sharing this in a very simple way.

[@nadiamalen]

Thank you so much, this was such an easy fix!

[@ardade123]

OMG - Thank You! I was racking my brain on why the time was not adding!!@!!!, your the best!

[@Anspol]

Thanks! That was very easy to understand and implement.

[@pattyg982]

OMG! The 24 hour thing had me so stumped! Thank you for the super simple fix!

[@thehollyclacyfoundation2521]

Brilliant Brilliant Brilliant!!!!!!

[@paulsane7136]

Best teacher..😊👏

[@Army1SGRetired]

That totalling was driving me NUTS, thanks for the simple format solution!

[@AmoreLifeDigitalNomads]

and where might we find the "previous" video you refer to where you show how to format the cell where the calculation is done? I have watched 5 videos and none of them provide the formatting info for that cell.

[@Caersy]

You saved my day! Well explained All my thumbs up!

[@Forediting-dp9hi]

thank you!!

[@nurulrashidahsalwarahim7860]

THANK YOU SO MUCH! I GOT STUCK AT THE WRONG CALCULATION OF HOURS AND YOU HELPED ME SOLVED IT.

[@merraricbusgov]

Goodness. Thank you so much!

[@danymjohnny6957]

Hi, These videos are amazing. I have a question though. How can we calculate if during work, we take a break for 30 mins?

[@syedmuzzammil9130]

Thank you so much brother, I work in transport company I am supposed to share vehicle idle time I always face problem when it exceeds 24hr. You made it easy for me... Thank you and god bless you

[@jru26273]

thanks a mill!!!

[@encounter12]

Awesome, I was stuck also with the 24 hours overflow, thank you so much!

[@JAYS040787]

Very helpful, thank you. I thought I was going crazy unable to solve it hahaha

[@petrupietersen6116]

Good day, @ExcelQuickAndEasy Thank you so much for this video, but I would like to find out if you can maybe assist with a formula for the following: For example, I am working Wednesday night from 22:00 pm till 00:15 am which is the next day the morning. How can I calculate that in the same row so I don't need to use 2 different rows to work it out? Thank you.

[@peterheath614]

thank you. You saved me hours!

[@Manisa-ce1oy]

Thank you for usful information. Why my hours auto sum is giving more than actul sum with calculator? Does auto sum rounds up? or am I doing somewhere wrong?

[@FaithMcCaffrey]

im getting the same thing. its irritating but i dont know how to fix. even in this video it added 40 seconds more than a calculator would. or are we not accounting for the 60 second to a minute thing? someone help

[@FaithMcCaffrey]

figured it out, if you've formatted your cell as [h]:mm then autosum will account the sum in time (hours, minutes, seconds) and not in hundreds (how we normally count). so it looks wrong but it isn't and you just have to trust the process. also to figure out your hours worked for each day, you do =MOD(end time-start time,1) and it does it for you.

[@alexiak8071]

how do I get the little SUM sign at the left hand corner of the table?

[@ally-xs2wl]

Thank you for this, i was literally about to cry

[@emilydavis5762]

thank you so much! very helpful

[@nashran9571]

Thank you so much!

[@zakiarahmoune7458]

Thank you !

[@jonathanpease5845]

Worked a treat, thank you.

[@rajatbhat794]

Thank you. 😀

[@Veb000]

Thank you

[@suzanne3t]

I've watched your video after setting up the Time In and Time Out columns according to Microsoft's how-to. Entered some data, so far so good. The individual call times are calculated in a Call Length column. No matter what I do, the sum returns 0.00. Can you help?

[@carlibagwell2673]

I am running into the same problem! :(

[@OoDiyaaoO]

It's a formatting issue, try adding "+0" to all 'Hours Worked' cells and it should work. If that didn't make any sense then you can watch this: kzbin.info/www/bejne/nmmYZWaDrNOhitU&ab_channel=ContexturesInc.

[@AliAbbas-uh4oy]

Thanks, sir.

[@simonereddy7004]

your videos have been so helpful. Thank you. How do I add in a lunch break colum? E.g if i need to subtract 45minutes from the total hours worked. TIA

[@simonereddy7004]

OR add a colum for lunch breaks that i can add up then deduct from the total hours work from that week. Thanks

[@theprojectiv8435]

Now, how would I format hours into a number that can be used in another calculation?

[@cw4933]

=(D3-E3)*24 and change format to general. Source: kzbin.info/www/bejne/fobNeq2Ljd2ompo

[@stellateo-griffin2243]

Hi, I tried the tutorial and is helpful. But when I add up the total it is not correct. Like the tutorial above, your total should be 48.03 but you got it as 48.43. That happens to me too. Please explain? Thank you.

[@OoDiyaaoO]

Had the same problem but finally managed to solve it! It's a formatting issue, kinda hard to explain in text so this is the tutorial that helped me: kzbin.info/www/bejne/nmmYZWaDrNOhitU&ab_channel=ContexturesInc.

[@sergiojosu3612]

how can i do it on libre office calc?

[@mc95]

Time-saver! Thank you for this.

[@lokiloki3391]

Thank you so much....it worked out

[@sunled5602]

This helped me a lot. Thank you for making this.

[@gabrielsilviu878]

ok, now if a make a sum for 10:00+09:30 the result is 1123:30 how ?

[@nishantgola139]

Thanks a lot. You solved my problem.

[@insatiable0610]

How do you calculate work hours minus lunch (30 minutes unpaid) and keep track of breaks (paid) to make sure you don’t go over allotted time?

[@ExcelTutorialsEasyClickAcademy]

Hello, we notice this question and it will be one of topics for next tutorial :)

[@daihanviet]

@@ExcelTutorialsEasyClickAcademy Hi have you done that tutorial video yet? I too am waiting for that one, thanks!

[@com7800]

Hello frank how do i do timetable i try ur step uk its add1 hours extra

[@charitagunter4025]

You saved me so much work! Thank you!

[@BifolikaDesigns]

Why you don't tell in this video how to format the cell for time calculations?

[@LotusGtRY]

Greetings! Is there a way to make a SUMMING CELL empty, UNTIL something is typed in cells that are going to be summed? It is so confusing on big time tables. Thank you very much!

[@insatiable0610]

Also, I’m curious. I have a protected worksheet, I want to copy all of the formatting on to a new workbook so I can edit it with my personal information. Is there a way to do this? I have so many questions.

[@ExcelTutorialsEasyClickAcademy]

Hello, we are glad you are interested in Excel. Unfortunately, we haven't prepared a video tutorial about this topic. Anyway, we notice this problem and we will try to prepare a tutorial about it in the future. But shortly, try to unlock that protected sheet and then copy formatting. It might work :)

[@lynnraypardo]

thank you!

[@TheColognePatron]

Thank you so much! Very informative!

[@ExcelTutorialsEasyClickAcademy]

You are wellcome. Thanks for your feedback :)

[@jujumomah]

Hi! This helped me so much. However, can you do tutorial on how to get remaining number of hours to render?..

[@alvojacobs7948]

How to adjust school bell time when time is added or deducted? 😢

[@jeremycrawford1775]

I'd like to see a video on how to calculate money made by the total hours worked.

[@sheenajohn2984]

Very easy to follow. Thanks a million

[@joannerakim2865]

mine did not work it just changed into brackets. but the wrong number. help please

[@raghuchandraashu8550]

I'n Android spreadsheet what can I do

[@muhammedrashidkp9581]

Thanks

[@jamiemarchant]

That last bit with the formatting confused me, when I tried to do it on my own, thanks.

[@politecat8253]

Omg you saved me

[@cecilpaul2271]

Thank You so much, absolutely brilliant and this has saved me so much time Cheers

[@ExcelTutorialsEasyClickAcademy]

Cecil, it's been a pleasure helping you :) Thank you for your feedback :)

[@deanllywelyn1098]

well mine didn't work i was just trying to add time up ...

[@mr.lygaming]

thanks so much

[@ExcelTutorialsEasyClickAcademy]

Try You’re Welcome :)

[@khurrammansoor9805]

Easy Method Using thank you

[@ExcelTutorialsEasyClickAcademy]

Khurram, it's been a pleasure helping you :)

[@Nei88]

What if you want to add another name

[@sergiojosu3612]

becouse i dont fine the custom area

[@Oceaneyes913]

How do I subtract 30 minutes for lunch taken?

[@khanhbui4223]

How do I even do the hours in the first place. Nobody's explaining.

[@RayPublicHealth]

Thanks for the [h] tip!

[@m.m.rahhal]

sum function not work , i use (+) to sum cells

[@mohis4299]

Thought something wrong with my formula. Excel should be intel enough to detect it.

[@BMVLifestyle]

Why is my SUM only giving me 0.00?

[@LukeB83]

Hi, this was happening to me. If you are exporting from SAP or another database, excel will think it is text. Changing the format will NOT fix this. To correct it, select each cell and put your cursor on the end of the time and hit enter in the function bar. This way excel 5h8nks you have just inputted it yourself. There may be a better way but this worked for me

[@joachimlaberg126]

@@LukeB83 saved my day! Thank you :-D

[@Soulzen_Sensei]

just a suggestion your giving us a tutotorial to add up time and you send us to another video to do time formatting? dumb idea just have it on the same video?

[@hashim3332]

I always got 0 answers when i do this

[@mehediofbd]

How to do this shit on office mobile...???

[@wolfmanwarman]

Wtf did it exactly as you said and its showing only 6 hours. When the first two cells being added will total 12!

[@MarvinRodgers-c8p]

does not work. total hours is calculated incorrectly

[@arshadmohamed6556]

😮

[@courtesyofeden]

help

[@coilYTcoyle]

your presentation is blurred

[@hariharan7991]

Thanks a lot