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
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.
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.
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
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?
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.
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?
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
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.
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?
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: ua-cam.com/video/h8543MwnnTs/v-deo.html&ab_channel=ContexturesInc.
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.
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: ua-cam.com/video/h8543MwnnTs/v-deo.html&ab_channel=ContexturesInc.
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.
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 :)
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!
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?
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
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
Thank you so much! I was stuck for days and couldn't figure out how to properly sum hours, this is fantastic!
OMG - Thank You! I was racking my brain on why the time was not adding!!@!!!, your the best!
Thanks you for sharing this in a very simple way.
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.
Thank you so much, this was such an easy fix!
Thanks! That was very easy to understand and implement.
OMG! The 24 hour thing had me so stumped! Thank you for the super simple fix!
Very helpful, you are my teacher!
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.
THANK YOU SO MUCH! I GOT STUCK AT THE WRONG CALCULATION OF HOURS AND YOU HELPED ME SOLVED IT.
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
That totalling was driving me NUTS, thanks for the simple format solution!
Very helpful, thank you. I thought I was going crazy unable to solve it hahaha
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?
You saved my day!
Well explained
All my thumbs up!
Best teacher..😊👏
Awesome, I was stuck also with the 24 hours overflow, thank you so much!
Thank you for this, i was literally about to cry
Brilliant Brilliant Brilliant!!!!!!
thank you. You saved me hours!
Goodness. Thank you so much!
thank you so much! very helpful
thank you!!
Worked a treat, thank you.
Thanks a lot. You solved my problem.
Time-saver! Thank you for this.
how do I get the little SUM sign at the left hand corner of the table?
Hi,
These videos are amazing. I have a question though.
How can we calculate if during work, we take a break for 30 mins?
thanks a mill!!!
You saved me so much work! Thank you!
Thank you so much!
Thank you !
This helped me a lot. Thank you for making this.
Thank you
Thanks, sir.
Thank you so much! Very informative!
You are wellcome. Thanks for your feedback :)
Thank you. 😀
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.
how can i do it on libre office calc?
Thank you so much....it worked out
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?
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
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.
Very easy to follow. Thanks a million
thank you!
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
OR add a colum for lunch breaks that i can add up then deduct from the total hours work from that week. Thanks
I'd like to see a video on how to calculate money made by the total hours worked.
Hello frank how do i do timetable i try ur step uk its add1 hours extra
How to adjust school bell time when time is added or deducted? 😢
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?
I am running into the same problem! :(
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:
ua-cam.com/video/h8543MwnnTs/v-deo.html&ab_channel=ContexturesInc.
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.
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:
ua-cam.com/video/h8543MwnnTs/v-deo.html&ab_channel=ContexturesInc.
ok, now if a make a sum for 10:00+09:30 the result is 1123:30 how ?
Why you don't tell in this video how to format the cell for time calculations?
Hi! This helped me so much. However, can you do tutorial on how to get remaining number of hours to render?..
I'n Android spreadsheet what can I do
mine did not work it just changed into brackets. but the wrong number. help please
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.
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 :)
Thank You so much, absolutely brilliant and this has saved me so much time
Cheers
Cecil, it's been a pleasure helping you :) Thank you for your feedback :)
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!
Now, how would I format hours into a number that can be used in another calculation?
=(D3-E3)*24 and change format to general.
Source: ua-cam.com/video/HUjIzUXxud8/v-deo.html
Thanks
Easy Method Using thank you
Khurram, it's been a pleasure helping you :)
thanks so much
Try You’re Welcome :)
That last bit with the formatting confused me, when I tried to do it on my own, thanks.
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?
Hello, we notice this question and it will be one of topics for next tutorial :)
@@ExcelTutorialsEasyClickAcademy Hi have you done that tutorial video yet? I too am waiting for that one, thanks!
Omg you saved me
well mine didn't work i was just trying to add time up ...
What if you want to add another name
becouse i dont fine the custom area
How do I subtract 30 minutes for lunch taken?
sum function not work , i use (+) to sum cells
Thanks for the [h] tip!
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?
How do I even do the hours in the first place. Nobody's explaining.
How to do this shit on office mobile...???
Thought something wrong with my formula. Excel should be intel enough to detect it.
Why is my SUM only giving me 0.00?
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
@@LukeB83 saved my day! Thank you :-D
I always got 0 answers when i do this
Wtf did it exactly as you said and its showing only 6 hours. When the first two cells being added will total 12!
does not work. total hours is calculated incorrectly
help
your presentation is blurred
😮
Thanks a lot