How to Make an Employee Timesheet in Google Sheets
Вставка
- Опубліковано 14 тра 2024
- Learn how to create an Employee Timesheet in Google Sheets. Just follow this simple step-by-step process.
This timesheet will allow you to track work time over any number of weeks, and it is super easy to share with others.
SPREADSHEET LINK
spreadsheetlife.myflodesk.com...
GOOGLE SHEETS COURSE
spreadsheetlife.com/google-sh...
OTHER
Templates: spreadsheetlife.com/templates/
Blog: spreadsheetlife.com/blog/
Music by Epidemic Sound
#googlesheetstutorial #googlesheets
thanks. good job
😄👍
I appreciate your efforts!
I gained a lot from this 👏🏾
That's so amazing to hear! I'm so glad that you were able to gain so much from this video! 😄👍
Very nice video and presentation, thank you very much!
You're very welcome. Thank you so much for your feedback. I'm so glad you enjoyed the video! 😊
I have problem with night shifts , the timesheet does not count hours from 22:00 to 06:00 but it shows -16:00 insted, i hope you can help me find a solution.
Thank you for the guide it was great.
I'm super glad you enjoyed the video.
Unfortunately, the original design is not created to handle night shifts as you have discovered. However, it is certainly possible to update the formulas to get it to work properly.
Check out this spreadsheet below.
docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
You will find that I use the IF function to check how the times are related and then the proper calculation is performed accordingly. I hope this helps.
Can you make a video on how we can have an employee clock in and out on a form. I made a form but I’m not sure how to make it easy for them to access for repeat entries.
What a cool idea! To clarify, are you trying to accomplish this using Google Forms to capture the information and store it in a spreadsheet?
@@spreadsheetlifeSir, how to make this for more than 1 employee
Unfortunately, this is only designed to be used by one person. A different approach would be needed to make it for multiple employees. I might make another one for multiple employees in the future, but I have quite a few videos in the queue that I need to take care of first. However, if you're interested, I do custom work for those who are interested when I have time. You are welcome to email me at info@spreadsheetlife.com for more info!