How to Make an Employee Timesheet in Google Sheets

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
spreadsheetlif...
GOOGLE SHEETS COURSE
spreadsheetlif...
OTHER
Templates: spreadsheetlif...
Blog: spreadsheetlif...
Music by Epidemic Sound
#googlesheetstutorial #googlesheets

[@MrBobWareham]

This would be a very good tutorial if there was no music! You have the details right and the speed, just stop the music as it is distracting, but I have joined your channel anyway as it is the best tutorial I have found. Thanks, Bob in the UK.

[@spreadsheetlife]

Thank you so much for the feedback! I will be sure to learn from this and keep the next videos free of music during the building process for sure. 😊👍

[@favenstein3574]

I appreciate your efforts! I gained a lot from this 👏🏾

[@spreadsheetlife]

That's so amazing to hear! I'm so glad that you were able to gain so much from this video! 😄👍

[@jeangreen432]

Very nice video and presentation, thank you very much!

[@spreadsheetlife]

You're very welcome. Thank you so much for your feedback. I'm so glad you enjoyed the video! 😊

[@mdekramhossain9764]

Really Appreciate to your video

[@spreadsheetlife]

Thanks so much! Super glad that you enjoyed the video! 😊

[@kimmiller474]

Well done!! Very easy to follow and instructions were clear... thank you for sharing. Can you help me expand on this timesheet? 1) I have multiple clients I often work hours for on the same day - I need to be able to insert additional lines with the same dates. I added a column 'Client' for which I can create a dropdown box. 2) I need the summary sheet to total time by Client - by Week - by Month - How would I take the sheet so that it calculates hours weekly, but with an open run for all the days in the month? thanks for your help

[@spreadsheetlife]

I'm so glad that you enjoyed the video! Send me an email at [e-mail], and we can go from there. 😊👍

[@hiteshchauhan1912]

thanks. good job

[@spreadsheetlife]

😄👍

[@KraftyMix]

How would you account for someone leaving for a medical appt? Do we just subtract that time manually and input the actual hours worked? Would it be possible to add columns for appt or multiple appts in a day?

[@spreadsheetlife]

The easiest thing to do would probably be to add more columns in the middle for more IN and OUT times. To do this, select columns D & E, right-click on the column headers, and insert two columns to the right. You can then update the formula to include the new columns. Please see the spreadsheet below for reference. docs.google.com/spreadsheets/d/1SunMU038hD7TqbiSn7wn8S1jhSBLBV88rLlN12CfyMQ/copy

[@KraftyMix]

@@spreadsheetlife thank you so much for the quick response :)

[@spreadsheetlife]

Of course! I do my best. 😊

[@Kusa1313]

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.

[@spreadsheetlife]

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.

[@amandamartinez7922]

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.

[@spreadsheetlife]

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?

[@Prodigious2345random]

​@@spreadsheetlifeSir, how to make this for more than 1 employee

[@spreadsheetlife]

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 [e-mail] for more info!

[@EvandroPastor]

The music is so annoying. The tutorial is great tough.

[@spreadsheetlife]

Thanks so much for the feedback! Super glad you enjoyed the tutorial, but I'm sorry about the music. As I learn on my content creation journey, I think keeping the music contained to the Intro and Outro is the way to go for videos like this. So I will do better in the future! 😊👍