Google Sheets - Timesheet, Overtime, Holiday Hours, Logical MAX & MIN Functions
Вставка
- Опубліковано 25 сер 2024
- First Part: • Google Sheets - Timesh...
In this tutorial we'll add overtime & holiday hours to our timesheet template in Google Sheets. We'll also introduce the idea of logical MAX & MIN.
Final Spreadsheet:
docs.google.co...
#googlesheets #timesheet #overtime #formulas
That use of the MIN and Max function is really clever!
thank you so much I have to log my hours on my own to make sure I get paid properly and your two videos have helped me so much doing gods work.
How about if we apply breaktime in morning and afternoom each 15mins? And also lunchbreak 1hr?
YOU ARE THE MFKN MAAAN!! Helped sm, good thing I lied on my application when I got you 😂🙌
Could you please show a way to get a let's say 8 hour shift and divide that shift up into different pay rates. So it could be 4 hours at $10 and 4 hours at $10.50. Thanks.
Always! Great Videos, Thank you.
Hi. I see a tab on 'weekly timesheets', was hoping you would do a video on that.
My work doesn't worry with the booking in and booking out times (although important, not needed if manged correctly).
But we have about 160 staff on satellite sites and have to book them weekly.
Mon - Sun.
Anything over 45hours in a week (Mon-Sat) is overtime, Sun Double time, Public Holiday double time (not included of Normal time).
To create this sheet where you can still pull reports per staff member, or per site, or manager becomes cumbersome.
Although self serving, I also thought this would be a great way to explore Dashboards, reporting, if statements etc.
PS: Thank you for all the videos. Big fan, I watch every moment I have a chance. Still getting through all the videos and far behind on my scripting. Thanks again.
The video he covers this in is here:
ua-cam.com/video/Xl646S9mQ20/v-deo.html
@@JMGauthier Thank you
Very helpul and much appreciated. Thanks.
if there are many people in the company, what is the sample way by calculating the salary, OT in google sheet? as you know that each staff has there own staff code.
We have overtime rules that can be very complex. First two hours over 38 hours per week mon-Fri is 1.5, unless it’s after 8pm, where its 1.5 for first 2 hours, excepting one day a week up until 9pm, after 2 hours or on Saturday afternoons it’s x2, sundays x2, public holidays x2.5..
Thank you
Hi there just getting into Excel , and learning Quite a bit from your channel. I do have a few questions -is it possible to have different rates for different jobs same day/hours or vice a versa and how to calculate the totals of that.
For example I have a guy that works two jobs on a Monday at different rates(one with travel time) and then maybe one job on Tuesday , and may vary the rest of the week.
I tried to add it in (like an overtime) but doesn’t compute correctly….
Would love to know how to add additional OT rates to this as I am missing something. For instance, the first OT cell would need a minimum of 8 hours with a maximum value of 12 and the second OT cell I could then set using the info in your video. So I guess I just need to know how to have a minimum and max value in the same cell or maybe there is a better way to carry over numbers from box to box. Thanks for great tutorials either way!
I am super new to excel and I have followed the first video time sheet to calculate my hours.
For me after 8 hours the first 2 hours are at 1.5 and every thing after that is at double.
I am after some help in a video to show me how to do all that
Thanks
Thank you very much bro
Thank you very much for these videos. Just wondering how i could go even further with the IF command.
I am wanting to calculate hours greater than 10pm for additional penalty rates. Ihave started with the following formula however it is not working as yet.
=IF((TIMEVALUE(E3)>TIMEVALUE("10:00 PM"),MOD(E3-(TIMEVALUE("10:00 PM",1)*24),0)
What i am wanting it to do is:
If the end time (E3) is greater than 22:00 (10pm), subtract end time (e3) from 22:00 to give number of units
If end time (E3) is less than 22:00, enter 0
How to mark if it is sunday, the cells below is blocked with Red. I can easily use conditional formatting in Excel, and not find out yet the formula for google sheets.. Thanks
Hi. we play with the workmates who tip the most rows on the Europatipset (Sweden; series of 13 matches).
And now I have created a spreadsheet about who has how many right. Everything works until we have some with the same number right.
I have a formula that finds the most number right and writes in the cell next to the winner's name. But if they are two or more? how to write all the names that are right? Thanks!
I like your Videos.
Where's breaks?
Will it be possible to create a Timesheet Control System in which a variable number of employees fill their own individual Timesheet in separate Google Sheet files and have a centralized Google Sheet ("Master Timesheet") that collects the information available in all the employees Timesheets, only when the employee Timesheet has been marked as finished by changing a specific value in a cell (a checkmark box, for example)? Thank you in advance.
any luck??
@@rfservicesinc.5801 Yes. We have done it. It works well.
@@JuanAguilar-Cardon would you be willing to shared ?
@@soundsofthemind2026 Unfortunately, the scope of the project was broadened to include some particular objectives for the company, so we now have 4 kinds of worksheet levels conected and working together. Nevertheless, if you want to know more, we can refer you to the project consultant we hired for the job: codementor.io/@rbn. I hope this helps.
hi there! how about how to compute if there are any late deductions? can you also make video where time in has minutes? example: time in is 9:30 am then out is 5:25 PM. how do we round out that? and how to compute late deductions?
Hi can you pls add on colum wer can i see how many min. Im late in a day
do you know how to count military hours in a military time schedule?
Hi, how to take away 30 min brake from hr. Please
Thanks...
How would I create an unpaid break time formula?
same formula ad -1 for one hour break, -0.5 for half hour break, etc.
And how to add a night diffential and its computation
What do you mean by "night differential"? MOD(endTime-startTime,1)*24 works for overnight shifts.
Hello Sir.
Any chance you can do a follow up on this timesheet, that would be awesome... pretty please. 🙂
Working hours with different rates, like day vs night.
Something like from 6AM to 10PM, multiply that with $50
And from 11PM to 5AM, multiply that with $70
Asking because I can't find anything about it and I really having a hard time to do it as I'm not sure how.
Use IF AND functions.
@@ExcelGoogleSheets Dear Sir, I did try but having problems whit it and can't find any video about it.
If you get some time on a beautiful day, please make a video about it, that would be awesome, thank you for all the work that you do. :-)
👍🏻