Thank you, just what I was looking for. Your video is the quickest and simplest. Way simpler than converting times into decimals, separate hour/minutes divided by 60 column, converting the decimals back into hours divided by 24 hours in a day.
excellent stuff been looking at lots of videos and yours was the first I came across that said use duration for the lunchbreak that's where I was going wrong thankyou so much
Thank you for the video. i keep getting this Value error: The MINUS function, parameter 1 expects numeric values, but «10:15» is a text and cannot be forced to a number. What do i do?
Hi but is there any option to show time with miliseconds? I need to compare times from driver A and driver B (minutes:seconds.miliseconds) I've done my best :/
In this example in the "making a timesheet" section, it would be cell E9 * Hourly rate would equal weekly pay if that is what you are trying to calculate
@@ModernSchoolBus That doesn't work. It will give you a correct calculation but formatted in a time format. In this example, if you multiply E9 by $100, you end up with 650:00. If you try to convert to a number or currency format, it ruins the calculation. Must convert either the result or the time to hours. So either E9*100*24 or as an interim step. F9=E9*24 (formatted as a number), then F9*100
I've tried your way of adding time. However, I have values such as 2pm to 4am. The difference comes out as negative. How do you that in that give time?..
Yes, I see now that when you cross midnight the time becomes a negative number. One way to fix this is to add this to the end of your formula "+(End_time
Do you have a video showing how to calculate the lunch break where the time might vary each day? Like a clock in/clock out situation for lunch as well subtracted from the total time worked? Thanks!
Yes, if you skip to 4:40 in this video I show an example where I create a timesheet. The start time, lunch break, and end time can all vary each day and the formula will calculate the total hours worked
Thank you, just what I was looking for. Your video is the quickest and simplest.
Way simpler than converting times into decimals, separate hour/minutes divided by 60 column, converting the decimals back into hours divided by 24 hours in a day.
Great time sheet. If you'd like to calculate OT, use this formula: '=if(C2
Awesome addition Libby!
this is the simplest explanation. loved it.
excellent stuff been looking at lots of videos and yours was the first I came across that said use duration for the lunchbreak that's where I was going wrong thankyou so much
life saver thank you
thank you! It was straightforward and exactly what I need for ojt
Thank you so much. This helped me immensely!!
Thank you! I didn't know there was a Duration format :)
awesome, just save me lots of time
That's actually what I was looking for thx a lot
Great video!
But I'm having problems with times that start at 3pm and end at 12am
Thank you for the video. i keep getting this Value error: The MINUS function, parameter 1 expects numeric values, but «10:15» is a text and cannot be forced to a number.
What do i do?
Thanks so much. It helps
2:03 thank you so much
Hi but is there any option to show time with miliseconds? I need to compare times from driver A and driver B (minutes:seconds.miliseconds) I've done my best :/
Super!
Good Job, 👍
thanks
thanks bro
How would you calculate the final hours worked cells to multiply by hourly rate to $ £ etc?
In this example in the "making a timesheet" section, it would be cell E9 * Hourly rate would equal weekly pay if that is what you are trying to calculate
@@ModernSchoolBus That doesn't work. It will give you a correct calculation but formatted in a time format. In this example, if you multiply E9 by $100, you end up with 650:00. If you try to convert to a number or currency format, it ruins the calculation. Must convert either the result or the time to hours. So either E9*100*24 or as an interim step. F9=E9*24 (formatted as a number), then F9*100
@@RobertMalt Yes! That is a good catch. I did not notice that before.
I've tried your way of adding time. However, I have values such as 2pm to 4am. The difference comes out as negative. How do you that in that give time?..
Yes, I see now that when you cross midnight the time becomes a negative number. One way to fix this is to add this to the end of your formula "+(End_time
Do you have a video showing how to calculate the lunch break where the time might vary each day? Like a clock in/clock out situation for lunch as well subtracted from the total time worked? Thanks!
Yes, if you skip to 4:40 in this video I show an example where I create a timesheet. The start time, lunch break, and end time can all vary each day and the formula will calculate the total hours worked
@@ModernSchoolBus Thanks for the tutorial sir, but how about the midnight shifts, I'm getting problems on that