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.
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
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?
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
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.
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: ruclips.net/video/h8543MwnnTs/видео.html&ab_channel=ContexturesInc.
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.
Add some additional columns - you could either record the start and end time of your break (then use a subtraction to calculate the duration), or the just add a column to record the duration. Then subtract that from your total hours worked.
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.
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!
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: ruclips.net/video/h8543MwnnTs/видео.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 :)
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
Thanks you for sharing this in a very simple way.
Thanks! That was very easy to understand and implement.
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.
Very helpful, thank you. I thought I was going crazy unable to solve it hahaha
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
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?
Thank you so much! I was stuck for days and couldn't figure out how to properly sum hours, this is fantastic!
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!
THANK YOU SO MUCH! I GOT STUCK AT THE WRONG CALCULATION OF HOURS AND YOU HELPED ME SOLVED IT.
Why you don't tell in this video how to format the cell for time calculations?
OMG! The 24 hour thing had me so stumped! Thank you for the super simple fix!
Thank you for this, i was literally about to cry
OMG - Thank You! I was racking my brain on why the time was not adding!!@!!!, your the best!
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.
Awesome, I was stuck also with the 24 hours overflow, thank you so much!
Very helpful, you are my teacher!
Thank you so much, this was such an easy fix!
Brilliant Brilliant Brilliant!!!!!!
You saved my day!
Well explained
All my thumbs up!
how do I get the little SUM sign at the left hand corner of the table?
well mine didn't work i was just trying to add time up ...
thanks a mill!!!
Goodness. Thank you so much!
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:
ruclips.net/video/h8543MwnnTs/видео.html&ab_channel=ContexturesInc.
Best teacher..😊👏
thank you. You saved me hours!
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 to adjust school bell time when time is added or deducted? 😢
Hi,
These videos are amazing. I have a question though.
How can we calculate if during work, we take a break for 30 mins?
Add some additional columns - you could either record the start and end time of your break (then use a subtraction to calculate the duration), or the just add a column to record the duration. Then subtract that from your total hours worked.
how can i do it on libre office calc?
I'd like to see a video on how to calculate money made by the total hours worked.
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.
Hi! This helped me so much. However, can you do tutorial on how to get remaining number of hours to render?..
Thank you !
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: ruclips.net/video/HUjIzUXxud8/видео.html
Thank you so much!
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
This helped me a lot. Thank you for making this.
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!
Thanks, sir.
How do I even do the hours in the first place. Nobody's explaining.
Time-saver! Thank you for this.
You saved me so much work! Thank you!
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!
Thanks a lot. You solved my problem.
Worked a treat, thank you.
thank you so much! very helpful
Hello frank how do i do timetable i try ur step uk its add1 hours extra
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:
ruclips.net/video/h8543MwnnTs/видео.html&ab_channel=ContexturesInc.
mine did not work it just changed into brackets. but the wrong number. help please
Thank you so much! Very informative!
You are wellcome. Thanks for your feedback :)
Thanks a lot
I'n Android spreadsheet what can I do
Very easy to follow. Thanks a million
Thank you so much....it worked out
Thank you. 😀
That last bit with the formatting confused me, when I tried to do it on my own, thanks.
thank you!
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 :)
Thanks
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 :)
Omg you saved me
Easy Method Using thank you
Khurram, it's been a pleasure helping you :)
becouse i dont fine the custom area
Thought something wrong with my formula. Excel should be intel enough to detect it.
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 subtract 30 minutes for lunch taken?
Thanks for the [h] tip!
sum function not work , i use (+) to sum cells
What if you want to add another name
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!
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
How to do this shit on office mobile...???
😮
help
your presentation is blurred
thanks so much
Try You’re Welcome :)