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.
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.
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
Great video! Thank you for keeping it simple and to the point! What do you do if you didn't take a lunch, and it seems that if you leave this blank, it screws up the calculations?
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
Click the big blue share button in the top right corner of the spreadsheet. You can then adjust the sharing options, and add the email addresses of your team members so that they have access to the document. I hope this helps.
Is there a way to add in hours for holidays or PTO? Since we usually just put down how many hours we are accounting for on a particular day for Holiday or PTO, I would have to put in a start and end time instead of just a total?
What you could do is just type in the number of hours manually in place of the formula on the desired date. That should work just fine. Just be sure to re-add the formula if you copy the worksheet for a new week.
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
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.
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!
@@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.
That's my bad. When I created the video, I forgot to account for overnight shifts. To deal with these, you need to adjust the formulas. Check out this spreadsheet where I've made the change. docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
To change the times to military time, select the time cells (B2:E8), then click the more formats button (123), select custom date and time, then choose the time format you want. I believe there should be a military time format you can select. And if not, you can always build it via the box on top. Finally, click Apply. I hope this helps.
You didn't do anything wrong. When I created the video, I forgot to account for overnight time differences like that. To deal with these, you need to adjust the formulas. Check out this spreadsheet where I've made the change. docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
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! 😊👍
works perfectly for me and your directions were clear and easily understood
That's so wonderful to hear! Thank you for sharing!! 😄
Thanks for making this! Extremely useful and easy to follow. Worked like a charm.
That's so awesome to hear! Thanks for watching!! 😄
Thank you so much! Very nice tutorial, step-by-step without confusion. It was so simple to create.♥
Thank you so much for the feedback! That's so awesome to hear, and I hope you enjoy using the spreadsheet. 😊👍
This is great - very helpful, thank you!
I'm so glad you found this to be helpful! 😊
This is amazing - thank you so much!!!
I'm so glad you enjoyed the video! Thank you for watching!!
so helpful. appreciate you and your patients
Yay!! 🎉
I'm so glad that you found this video helpful! 😊
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. 😊👍
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! 😄👍
So helpful. Thank you
I'm so glad you found this helpful! 😄
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.
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. 😊👍
Great video! Thank you for keeping it simple and to the point!
What do you do if you didn't take a lunch, and it seems that if you leave this blank, it screws up the calculations?
never mind, figured it out had the cells crossed thanks agian for a great toturial!
Awesome! I'm so glad you figured it out!! 😄🎉
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. 😊
How would I make this shareable so I can send to staff so they can document their time individualy and I can see it on my end for easy billing?
Click the big blue share button in the top right corner of the spreadsheet. You can then adjust the sharing options, and add the email addresses of your team members so that they have access to the document. I hope this helps.
Really Appreciate to your video
Thanks so much! Super glad that you enjoyed the video! 😊
Is there a way to add in hours for holidays or PTO? Since we usually just put down how many hours we are accounting for on a particular day for Holiday or PTO, I would have to put in a start and end time instead of just a total?
What you could do is just type in the number of hours manually in place of the formula on the desired date. That should work just fine. Just be sure to re-add the formula if you copy the worksheet for a new week.
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
Love the video. How can I add salary calculations to this?
I’m wondering the same thing!!
Send me an email at info@spreadsheetlife.com, and I can give you an idea or two!
Is there a way or formula to put down Holiday or PTO hours without entering a start and end time?
I responded to your other comment. 😊👍
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.
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!
thanks. good job
😄👍
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. 😊👍
Man not working for me
I work 12 to 14 hour shifts
17:15 to 07:00
It’s calculated 12.25
It should be 13:45
Also don’t need to remove the break time
That's my bad. When I created the video, I forgot to account for overnight shifts. To deal with these, you need to adjust the formulas. Check out this spreadsheet where I've made the change.
docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
Is there a formula for military time?
To change the times to military time, select the time cells (B2:E8), then click the more formats button (123), select custom date and time, then choose the time format you want. I believe there should be a military time format you can select. And if not, you can always build it via the box on top. Finally, click Apply.
I hope this helps.
I having a problem that 1pm in 1am out but results show -12😢
What did i do wrong?
You didn't do anything wrong.
When I created the video, I forgot to account for overnight time differences like that. To deal with these, you need to adjust the formulas. Check out this spreadsheet where I've made the change.
docs.google.com/spreadsheets/d/1BrmzJVE5YrI9fiqIVgzHgzEl-s1jlBbcIqf6vLTYLNQ/copy
Nothing works on my google docs youve suggested can you upload something worthy
Hi there! I'm sorry you're struggling to get it to work.
If you have specific questions, I'd be glad to help you figure them out the best I can! 😊👍
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! 😊👍