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.
thanks for this useful video, I followed all the instructions but it's not working on over time like for exmple i wills log in on 5 pm and log out 12 pm the result is negative. please give us advice how to resolve it thank you
Check out this spreadsheet. I think this will help answer your question. docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
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
HI THIS VIDEO WAS VERY HELPFUL - QUESTION - HOW CAN I MAKE THIS FOR MULTIPLE EMPLOYEES? I WANT THE EMPLOYEE TO ADD THEIR TIMES AT THE END OF THE SHIFTS. THEN I CAN ADD UP ALL THE HOURS IN THE SUMMARY TAB
Hi there! Unfortunately, this build isn't great for multiple employees to use at once. It's certainly possible, but it would require a few advanced modifications. I'm sorry that's the case.
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?
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
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.
@@spreadsheetlife I tried it in my sheet but it doesn’t work. I am only using one Time In and one Time Out column. (C2-B2)*24 Ex) Time In = 11:45 AM, Time Out = 4:00 PM, and the # of hours I got based on the formula above was 102
Fascinating. If you'd like, you are welcome to send me an email at info@spreadsheetlife.com and share a copy of your spreadsheet with me. I can better diagnose the problem that way.
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.
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!
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! 😊👍
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.
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. 😊👍
so helpful. appreciate you and your patients
Yay!! 🎉
I'm so glad that you found this video helpful! 😊
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! 😄👍
Really Appreciate to your video
Thanks so much! Super glad that you enjoyed the 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! 😊
thanks for this useful video, I followed all the instructions but it's not working on over time like for exmple i wills log in on 5 pm and log out 12 pm the result is negative. please give us advice how to resolve it thank you
Check out this spreadsheet. I think this will help answer your question.
docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
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
I'm so glad that you enjoyed the video!
Send me an email at info@spreadsheetlife.com, and we can go from there. 😊👍
HI THIS VIDEO WAS VERY HELPFUL - QUESTION - HOW CAN I MAKE THIS FOR MULTIPLE EMPLOYEES? I WANT THE EMPLOYEE TO ADD THEIR TIMES AT THE END OF THE SHIFTS. THEN I CAN ADD UP ALL THE HOURS IN THE SUMMARY TAB
Hi there! Unfortunately, this build isn't great for multiple employees to use at once. It's certainly possible, but it would require a few advanced modifications. I'm sorry that's the case.
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?
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
@@spreadsheetlife thank you so much for the quick response :)
Of course! I do my best. 😊
thanks. good job
😄👍
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.
What is the formula that correctly calculates the Hours?
Ex) 12:00 PM - 4:30 PM = 4.5 instead of 4:30
The formula is at 4:06 in the video. I go over how it works and why we multiply by 24. I hope this helps.
@@spreadsheetlife I tried it in my sheet but it doesn’t work. I am only using one Time In and one Time Out column. (C2-B2)*24
Ex) Time In = 11:45 AM, Time Out = 4:00 PM, and the # of hours I got based on the formula above was 102
Fascinating. If you'd like, you are welcome to send me an email at info@spreadsheetlife.com and share a copy of your spreadsheet with me. I can better diagnose the problem that way.
@@spreadsheetlife I think I found the problem! I needed to format to Number instead of Duration
Oh awesome! I'm glad you figured it out. 😊👍
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!
The music is so annoying. The tutorial is great tough.
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! 😊👍