Calculating Sum of Time in Excel

In this video, you will learn how to calculate the sum of time in Excel. We have demonstrated the different approaches to how you can make sure that the calculation you do to perform the sum of time in Excel provides you accurate numbers. With this video, you will be able to calculate and provide accurate results of time without errors.
While doing calculations of time in excel it happens that if you do not select the right format it will simply display the remainder of the time and not the actual value unless you change the format to the specific type.
By the end of this video, you will learn what is that type that will help you to show the accurate values and do the right calculations while performing the sum of time.
Also, focus on the locale information which is demonstrated in this video. If the proper locale is not selected you may not see the desired format with which you are trying to achieve the results shown in this video. As some of the locales do not carry the type of format that is required to achieve this type of output, you will need to change it to get the desired results.
Do not forget to watch the next video that we are going to produce which will help you to calculate the maturity of a given product based on a certain date or the maturity of a contract in a similar manner.
We hope that you are enjoying learning Excel through this Excel learning series videos. We request you kindly share these videos with the people who desire to learn Excel from scratch subscribe to the channel and click on the bell icon to continue receiving notifications about the new videos as and when they are posted to keep up with the learning.
Download the Practice File using: drive.google.c...
Free Excel Data for Practice: onlineknowledg...
This applies to:
Excel 2007 and above
#excelLearningSeries #excel #excel2016 #excelDateFunction #excelShortcuts #exceltime

[@derekhopper1431]

Brilliant! You have a great teaching style and get to the point really quickly. Very much appreciated.

[@Syedhussainipage]

So happy to hear that. Subscribe to our channel kzbin.info if you haven't already and click on the bell icon to enable notifications for updates. Best Regards, Syed H | myknowledgeportal.com/

[@Sundawg102]

I was scratching my head so hard I was giving myself a bald spot trying to figure out what I was doing wrong, what I was missing, and a quick search and I saw your video and you opened my eyes and I learned something today. Thank you so much for sharing your knowledge and making it simple enough to follow along.

[@Syedhussainipage]

I'm glad it helped and thank you for your feedback. If you haven't already, do subscribe to my channel and enable notifications by clicking on the bell icon to receive updates from my KZbin channel. Best Regards, Syed H | MyKnowledgePortal.com

[@Ellely143]

FINALLY!!! Took me years to find this simple solution to add up my work hours without giving me just the remainder. THANKS!!!!

[@Syedhussainipage]

Thank you for the feedback, it truly helps to keep motivated. I am so glad to hear that it worked for you. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@anthonyedison2388]

i realize I am quite randomly asking but does anyone know of a good website to watch new tv shows online ?

[@thiagoreginald4990]

@Anthony Edison lately I have been using Flixzone. You can find it by googling =)

[@elliottamari6472]

@Thiago Reginald Definitely, been using Flixzone for years myself :)

[@anthonyedison2388]

@Thiago Reginald thank you, I went there and it seems to work =) I appreciate it!!

[@EarlyRooster-lo6qu]

Thank you so much. I was searching this on internet for last 2 hours

[@abidchaudhary3439]

Thank you so much, I was looking for this for a long time and nothing worked for me except this,

[@BenEGNJ]

This tutorial has saved me countless hours. So easy to follow and the explanations are very good. Many thanks for your tutorials.

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@bridgetmc.738]

Very helpful! Took me a few tries to find this video; others were trying to sell some product, but I knew Excel must be able to do this :) Thank you!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@stephenjpmccarron9116]

Well explained especially the amount of time over 24 hours. Many thanks for posting this

[@Syedhussainipage]

Thank you for the feedback Stephen, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@danilynsuaybaguio7562]

Thank you for this video, it is the 'easiest' to understand.

[@Syedhussainipage]

Thank you for the feedback Danilyn, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@glennm900]

Simple and easy instructions with a very functional work book. Thank you .

[@Syedhussainipage]

Thank you for the feedback Glenn, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Have a wonderful day ahead! Best Regards, Syed H

[@josephcrocker5111]

this is the besttttt ~~~ i was losing my MIND trying to do this before i found this video!

[@Syedhussainipage]

Thank you for the feedback Joseph, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@ihtshamashraf-z1u]

Beautiful explanation Stay blessed and keep working

[@jamesdanley4561]

Excellent instruction on what I was trying to do in excel.

[@victortaboada2058]

Excellent video...wish I had found it a couple of hours ago...I was going crazy with this same issue in Excel. Thanks for this information!!!

[@Syedhussainipage]

Happy to hear that it was helpful. Do subscribe to my channel if you haven't already for updates. Best Regards, Syed H | PuzzleCheats.com

[@MrSpartacus895]

Excellent - best explanation I found

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@timboyle3702]

Thank you, thank you. I've been trying to correct the time total for over an hour and you answered it so simply.

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@64mustangfan]

Thank you! You earned a subscribe. This is a pesky Excel issue, solved 🙂

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. Best Regards, Syed H

[@CreativelyShay]

Exactly what I needed. Thank you!!😊

[@helpinghand7367]

Very good explanation. Many thanks

[@AbdullahAlMamun-mc4nq]

THIS IS A BEST VIDEO FOR THAT FORMULA , THANKS

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@catlillith]

Thank you so much for explaining an easy way to add time on excel.

[@Syedhussainipage]

Happy to hear that. Kindly subscribe to my channel if you haven't already and enable notifications for updates. Regards, Syed H

[@BizAndProductReviews]

Thanks for this video. It is the best one on how to do this that I have seen. You explained everything very well. Now I just have to apply what you taught to Google Sheets. Hopefully I am able to do the same things in Google Sheets that you were able to do in Excel.

[@1crocodile2crocodile]

Thank you Mr Hussaini - this was so helpful to me

[@Syedhussainipage]

I am glad I could be of service and thank you for such helpful words. Kindly subscribe to my channel if you haven't already for regular updates. Best Regards, Syed H | MyKnowledgePortal.com

[@ibrardil]

Thanks indeed Hussaini Sahib. Very Informative & helpful video.

[@Syedhussainipage]

Happy to hear such good words. Do subscribe to the channel if you haven't already and enable notifications for new video updates. Best Regards, Syed H | technicalsupport.blog/

[@moshemaor1731]

Very clear lesson. Good lecturer. Thanks.

[@Syedhussainipage]

Thank you Moshe. Do subscribe for regular updates. Have a lovely day ahead. Best Regards, Syed H

[@moshemaor1731]

Of course, I have subscribed and follow your videos. Thanks.

[@mrajpanchal]

Really great. Good explanation

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@gokmen9928]

Thank you, great explanation! Helped a lot! Regards..

[@Syedhussainipage]

Thank you for the feedback. Do subscribe to my KZbin channel for regular updates. Best Regards, Syed H | TechnicalSupport.blog

[@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?

[@umeshkumarbind9526]

Really it helped me. Thank you God bless you

[@Syedhussainipage]

Thank you for the feedback and blessings Umesh, it helps in keeping me motivated. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@katking02]

Great explanation, straight to the topic, clearly explained and shown. Thank you very much.

[@Syedhussainipage]

Thank you for the helpful feedback and motivation. Make sure to subscribe to the channel and enable the notifications receive updates and continue learning. Best Regards, Syed H | TechnicalSupport.blog

[@saamekini1638]

Awesome! Was trying from past 3 hours.. Thanks a lot

[@Syedhussainipage]

Glad to hear that it helped. Do subscribe to my KZbin channel for regular updates from my channel. Best Regards, Syed H | myknowledgeportal.com/

[@chennammamara6936]

Really it's work for me, thank you very much

[@makumbiandmark7688]

Thanks for what you have done, well do

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@paradiseV678]

Thank you hun. You save my day🙏

[@Phil_4_8]

Thank you so much. This was making me crazy.

[@superquran4512]

Your teaching earned my Sub :) and really liked the content though i didn't get what i was looking for but i'll not give up :D

[@MissSoull]

This mystery was really bugging me, as to why the status bar was summed correctly but the spreadsheet was not. After several searches through video's and figuring out a part of the error for myself, finding this video cracked the case wide open for me. I would not have known to check this part of the format cells without it! Many thanks.

[@Syedhussainipage]

Thank you so much for this feedback. It makes me happy to see that my work is helpful in some way. Do not forget to subscribe to my channel and enable notifications by clicking on the little Bell icon to get notified about new videos on my channel. Have a blessed day ahead. Best Regards, Syed H | technicalsupport.blog

[@jayfabby4731]

Thank you so much for the very simple yet really helpful explanation! I was able to do my job! Thank you so much!

[@Syedhussainipage]

Thank you for the feedback. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@WiliamBennettwildarbennett]

Thank you for simplifying this process. I can finally understand the process .

[@Syedhussainipage]

Thank you for the feedback. Please subscribe to my KZbin channel if you haven't already for regular updates. Best Regards, Syed H | MyKnowledgePortal.com

[@albashiriahmed]

Thank you for your clear and fantastic explanation

[@Syedhussainipage]

Thank you for the feedback Alzahrani, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@rhodge312]

Very good video on calculating time, but where to you get the sample you wanted us to work out?

[@Syedhussainipage]

It is there in description: bit.ly/2AM3y12

[@sujatahanumanthu501]

Amazing sir

[@rekharevathy623]

It was helpful. I have a query, how do we calculate average if the time is in the format : 00:16:28 and 00:16:41

[@Syedhussainipage]

Hello Rekha, Sorry for the delayed response. Just try Average function in place of Sum Function.

[@clios2004]

Excellent video sir! Great job!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@aaronag7876]

Great video, but I keep getting 00:00 in my sum field, the range is in time and they total field in time. Changed it to locate as US but makes no difference. Any idea ? Thanks

[@Syedhussainipage]

Thank you for the valuable feedback. Can you please share some sample data to look at and I'll be happy to assist. Mail it to [e-mail]

[@rajb19]

Very helpful, thank you.

[@Syedhussainipage]

Happy to hear that. Kindly subscribe to my channel if you haven't already to receive updates. Best Regards, Syed I PuzzleCheats.com

[@bsimpson6204]

Brilliant!! fixed it for me, thank you!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@michaeleisenbise4278]

Fantastic video. Helped me a great deal. Owe you one.

[@Syedhussainipage]

Glad to hear such motivational words. Do subscribe to the channel and enable notifications for regular updates. Best Regards, Syed H

[@jenniferalphonso9823]

Thanks a ton. This is exactly what I was looking for.

[@Syedhussainipage]

Jennifer Alphonso so glad to hear from you. Do subscribe to my channel for continued learning and updates on new videos. Best Regards, Syed H

[@rukhayyabatool8369]

thanks a million!

[@Syedhussainipage]

Thank you for the feedback Rukhayya, it helps in keeping me motivated. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@BruceFloyd]

Terrific video, sir!

[@Syedhussainipage]

Thank you for a wonderful feedback. Do subscribe to my channel and enable notifications for updates. Best Regards, Syed H | TechnicalSupport.blog

[@Petergdn]

HELP please, Syed! Thanks for you excellent video. I still have a problem with the time format if I want to calculate working hours for a month or a year. Can you help we finding the right format? Best regards Peter

[@Syedhussainipage]

Hello Peter, Can you share some sample data on my email [e-mail] so that I can look at it?

[@agriculturetonextlevel1382]

Excellent teaching

[@demensclay6419]

Very good, it's a life saver for me, but... what if you DO want those seconds to be counted as well?

[@Syedhussainipage]

Thank you for the feedback Demens, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. You may change the format to take the seonds into consideration. Please let me know if you need any help. Best Regards, Syed H

[@republiccan5203]

Thank you! Excellent presentation!

[@Syedhussainipage]

李博王 thank you for an appreciation. Do subscribe for continued learning and more new videos. Best Regards, Syed H | zaha.in

[@nithin7617]

Wow super 🔥

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@kwoh28]

thank you so much for this video!!! I tried for hours to figure out why the sum kept saying I only did 7 hours when I did 79.

[@Syedhussainipage]

Happy to hear that it helped you. Do subscribe to my channel and enable notifications for updates. Best Regards, Syed H | hmyknowledgeportal.com/

[@joeypucks7250]

Thank you but I am trying to add a group of cells that contain different lengths of time of videos that I have to review. So for example 4 videos I have in spreadsheet at Video1- is actually 1hr 30 mins & 10 secs long so I entered it into cell as 1:30:10, for argument sake lets say the other 3 videos are just 30 mins 10 sec's long, entered into cells as 30:10 each. So total length should read 3:00:40 but I cannot get the sum to work. It just gives me 0:00:00

[@Syedhussainipage]

It worked without any problem for me. [See drive.google.com/file/d/1DTnl9b2ORunqNHpZ5q7cNsL1vNmX3D-b/view?usp=sharing ] Can you please make sure all the cells are in same format HH:MM:SS and let me know if you are still facing the issue. I am looking forward to hearing from you soon. Regards, Syed H

[@joeypucks7250]

@@Syedhussainipage You are correct sir, thank you. I just tried it with a new clean spreadsheet. There must be something in the previous spread sheet that I was doing wrong. Thanks again!

[@Syedhussainipage]

@@joeypucks7250 I am so glad that it worked. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@BMVLifestyle]

Why am I getting 0:00:00? Great video to follow, just can’t understand why it will not SUM.

[@Syedhussainipage]

Can you please send me sample of data to look at?

[@BMVLifestyle]

@@Syedhussainipage I can tomorrow when I go back to work. It will add if I add each cell individually (=b2+b3+b4) but it won’t add with (=sum(b2:b4)) for some reason.

[@Syedhussainipage]

@@BMVLifestyle this is strange. I would love to look at some sample data, especially the set you are trying to sum.

[@ulfatahmad8430]

I am not able to sum the time I'll show you as 10055:00:00 in one cell 4:10 in another cell while adding these two cells in one row it shows #value in the next cell in same row. The format of cells is also same. Help me plz

[@Syedhussainipage]

Hello there, Thank you for your message. Can you please share sample data so I can check it for you. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6 Best Regards, Syed H

[@pclighting4]

Very helpful. Thank you

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@jimbo240880]

This should have more likes

[@Syedhussainipage]

Thank you James. Do subscribe for regular updates. Have a lovely day ahead. Best Regards, Syed H

[@mommababy1]

Thank you for this I really like the way you explain things as you are going along.

[@Syedhussainipage]

Thank you for the feedback. Do subscribe to my KZbin channel for regular updates. Best Regards, Syed H | MyKnowledgePortal.com

[@Loay-113]

Thanks So much

[@Syedhussainipage]

Thank you for the helpful words. Please subscribe to my KZbin channel kzbin.info if you haven't already for regular updates. Best Regards, Syed H

[@svs2siu398]

Greetings Syed, My Cells in question are = +K93 + L66 My Cells values in question are = 10:18:00 + 15:28:00 When I add the cell values on paper, they = 25:46:00 I have formatted the cell to Custom, [HH]:mm:ss = 49:46:00 I have formatted the cell to Custom, [H]:mm:ss = 49:46:00 I have formatted the cell to Custom, [H]:mm = 49:46:00 I have formatted the cell to Custom, HH:mm:ss = 01:46:00 I am trying to track accumulated hours (weeks) of Study.

[@Syedhussainipage]

Hello Dear, Not sure what is going wrong at your end. I did the calculations using the values you've shared and got the result 25:46:00. Download this sheet to see the sum: drive.google.com/file/d/1nEdwmoyYvJfp_REXW2r4xzfLM-a9qgxG/view?usp=sharing Make sure you are following the format I have shared. Let me know if you still face the issue. Best Regards, Syed H | puzzlecheats.com/

[@kalyinurbaialy5668]

Thank You so Much !!!!!!!!!

[@Syedhussainipage]

Glad to hear that. If you haven't already, please subscribe to my channel and click the bell icon to receive notifications about new content from our channel. Best Regards, Syed H I MyKnowledgePortal.com

[@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!

[@Syedhussainipage]

Yes, just try If(cell-to-be-summed="", "", Sum of time) Replace placeholders accordingly. Let me know how it goes. You may share the data sample in case you are facing difficulty for any assistance. Regards, Syed H

[@bevp4946]

Excellent video. thank you so much

[@Syedhussainipage]

Bev P thank you for your feedback. Do subscribe for updates and enable notifications for new video notifications. Best regards, Syed

[@z06etnlfntm97]

Great video! I am doing something wrong on my end along these lines but I haven't figured it out yet...

[@Syedhussainipage]

Thank you for the feedback. Is there something i can do to help? Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@z06etnlfntm97]

I’ll have to do a bit more checking first. Thanks - Will let you know

[@Syedhussainipage]

@@z06etnlfntm97 sure, I'll be around👍

[@surajmahato5129]

Hi Syed, can you please explain why do we need to select the locale format as 37:30 (English United States), why not the other one?

[@Syedhussainipage]

To show the hours when they exceed 24. I have explained it in the video. Hope you find this helpful.

[@tangosamba7192]

Will this work when calculating the total monthly hours with times which was calculated by using the IF formula?

[@Syedhussainipage]

If you could share some sample data, I can check it for you.

[@tangosamba7192]

@@Syedhussainipage thank you very much. i managed

[@Syedhussainipage]

@@tangosamba7192 I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@jalphonso1515]

How to compute work hours shortfall adjustment against leave?

[@rubelislam3001]

Thank you sir your tutorial lots of helps me

[@Syedhussainipage]

Happy to hear that. Kindly subscribe to my channel if you haven't already and clock on bell icon to receive notifications of new content. Best Regards, Syed H I MyKnowledgePortal.com

[@vinnavanarul2503]

Hello syed... Now am working on a excel sheet and i have a problem... I will tell my problem by taking your excel sheet for example, that you used in this video... In this video you have created week and week2 columns... In each column you have 5 rows... Incase if I want to add 01:00 hour in each row of week1 column what should I do... (I.e., B2(06:31+01:00), B3(04:38+01:00),B4,B5,...) In my case am working on hundreds of rows and am rewriting it on each row whenever I want to add time... Please help...

[@Syedhussainipage]

Dear Vinnavan, You will have to put the extra hours in a separate column and call it as a reference. Example enter the time in A2 and B2 and set the format as proper time. Now under C2, you may perform the totals i.e. =A2+B2 If you insert the time directly. it may not work as desired, however, when you call the same as a reference, it will work as desired. Hope this helps. Best Regards, Syed H | myblogginghelp.com

[@vinnavanarul2503]

@@Syedhussainipage creating another one column will make me trouble. Please tell some easy solution for my problem. I said am working on hundreds of rows. One set of information contains 10 to 30 rows. Like wise i have hundreds of sets. Here i have to add one hour in 3rd set and 4 hour 1st set and it varies on each set. So here, your idea will make my work burden bit more. So please give me easy solution.

[@tamyezalisaleh2800]

بارك الله فيك

[@SharanaGaddi]

Sir, I have this format of time 1h 26m and i have to calculate average time(consider all 16 sessions). Please suggest the formula

[@Mujees23]

Hi ,want to create a monthly report with specific task ,total output and total hours spent for each task .is there any easy way to do that..

[@Syedhussainipage]

I'll need some sample data with more information on what you need. I can then, hopefully, guide you accordingly.

[@AHMScary]

good videos sir

[@INAYAH_khan_official]

Hi, thanks for explaining the custom formatting of the time. In my worksheet the sum of calculated hours is coming more than the actual value , i did check the formatting as well and still not able to figure out why actual sum is more than that total hours, eg: i was calculating total annual leave hours and for 5 annual leaves the sum should come to 50 but its coming up as 170, i am very confused , what wrong i am doing. pls help.

[@mikesergo2036]

Thank you so much for this amazing video. Loved it 👍👍👍

[@Syedhussainipage]

Thank you for the feedback. Do subscribe to my KZbin channel for regular updates from my channel. Best Regards, Syed H | myknowledgeportal.com/

[@dacevosveniece5719]

Thank You so much!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@PawanVerma-f9v]

Sir, please give solution if sum of time exceeds 60 hours e.g. add below time 0:14:06 0:13:18 0:12:28 0:12:48 0:12:40 0:14:11 0:12:59 0:13:01 0:13:28 0:11:45 0:13:02

[@rishitshah4087]

Thank you sir how to calculate the sum for the particular date like more whole month have many different dates

[@Syedhussainipage]

You are welcome. Set all your dates in different columns and do the calculations. If you are pointing to something else, please share a sample of your data with me by uploading the sample file on Google Drive. If you haven't already, please subscribe to my channel for regular updates. Best Regards, Syed H I MyKnowledgePortal.com

[@haseebulhassan2220]

Just Use "Sumif" function

[@rishitshah4087]

@@Syedhussainipage thank you so much sir it helped me a lot

[@Syedhussainipage]

@@rishitshah4087 Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@Efkarpidis]

I use excel on my iPad Pro, can you explain how to do this on iOS

[@loosechange84]

Question what if on any day they have no time entered because they were off? How is that calculated?

[@Thatguy-xs9ge]

what im looking for is when u type in time in and time out for one day ,i need to see the total hours worked , ex 07:30 / 16:30 then it must give me 8 hours. im struggling

[@Syedhussainipage]

Thank you for watching my video. You will need to place three columns (Column 1 = Time In Entries and Column 2 = Time Out Entries) and in the last column substract the later time with older entry. See a sample I have done here with the values you have provided: goo.gl/S6NG8z Hope you find this helpful. Best Regards, Syed H

[@rajkishorrkshow2048]

This video is very helpfull

[@Syedhussainipage]

Thank you for the feedback Raj, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@Mssmuk]

wow, very helpfull thankyou :D

[@Syedhussainipage]

Thank you for the helpful feedback and motivation. Make sure to subscribe to the channel and enable the notifications receive updates and continue learning. Best Regards, Syed H | myknowledgeportal.com/

[@bablumiah297]

thanks helpfull video

[@angelica66140]

What if i also have seconds included in the format? I try to format cells in the Hh:mm:ss format but it will not count

[@Syedhussainipage]

Please change the format of the results and it should work. Share the data sample and I can check it for you if the above technique is not working for you.

THANK YOU!!!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@ashishkumarshukla3928]

so nice trick thank you so much

[@Syedhussainipage]

I'm glad to hear such helpful feedback. Do subscribe to my channel for regular updates. Best Regards, Syed H I MyKnowledgePortal.com

[@ShivendraMohanSingh]

How I can calculate days with this hours?

[@sravandhuduri]

I do have the same doubt

[@Syedhussainipage]

sorry for very delayed response. Please let me know if you are still looking for any help.

[@sravandhuduri]

@@Syedhussainipage I got it sir.. If you have any simple method pls let us know..

[@johnhopkins6565]

What if I need to add larger amounts, such as 30 - 40 hours per entry? The ()*24 won’t help me.

[@Syedhussainipage]

Hello John, Happy New Year!. If you could elaborate your question a bit more, I can get you a working solution. I am looking forward to hearing from you soon. Regards, Syed H

[@johnh7899]

So I have several clients that send payroll hours in hh:mm format, and my software only tracks it by decimal. Many times I need to enter this ‘on the fly’ over the phone, so I don’t have the time to refer to a conversion chart, or calculate mm/60 on every entry. Is there a formula or function that will convert hh:mm when hh is already greater than 24? Is the answer to divide the total of hh:mm by the number of total hours in my pay period, say 40/week or 80/ biweekly?

[@johnh7899]

Sorry, I just read my reply, I meant to say would I have to multiply the total time worked by 40 to get total hours worked in a week as a decimal.

[@mtabbasi]

Thanks seyed. How can I log the windows clock time in a cell?

[@Syedhussainipage]

You're welcome. You may use NOW function. Now() Hope this helps. In case you haven't already, please subscribe to my channel for updates. Best Regards, Syed I MyKnowledgePortal.com

[@fahimistihadanik1495]

Problem is I am using web version as it has limitations I cant customise [h]:mm i can only select [h]:mm:ss if anyone knows how to get rid of the extended ss in this version do let me know would be of great help. Thank you.

[@lukev730]

Thank you nice video I have a question for example I wanted to prepare staff working hours schedule I have starting and ending hours I want to make a formula for 24!hous which hour he was present Can you help me

[@Syedhussainipage]

Hello Luke, I apologize for missing your comment. Do you still have this requirement? I am looking forward to hearing from you soon. Syed H | technicalsupport.blog

[@AA-wi7rr]

Omg Thank you!!

[@blazze7772]

Thank you for this video!!

[@Syedhussainipage]

Blazze777 Happy to help. Do subscribe for new videos and more learning

[@PawanVerma-f9v]

Sir pls give solution if time excess 60 hrs in sum add below time 0:14:06 0:13:18 0:12:28 0:12:48 0:12:40 0:14:11 0:12:59 0:13:01 0:13:28 0:11:45 0:13:02