Employee Timesheet Using Google Forms and Google Sheets
Вставка
- Опубліковано 17 жов 2024
- This is a simple way to have employee's track their time.
If you would like to join the discussion on how to reduce your monthly costs as a healthcare business owner and request more how to videos please click this link below.
/ unsubscribedhealthcare
If you would like to purchase the pre-made templates or get a link for a FREE Superbill template follow the link below.
www.unsubscrib...
As always remember to Subscribe to Unsubscribed Healthcare for more helpful video's on how to make google workspace into a powerful business tool.
Hello, I wanna say thank you for your time very helpful. How would you implement breaks or lunches? Thanks 😊
The sweetest voice of your son :)))
They grow up so fast :)
I have just implemented this strategy for my team… I hope to come back in a few months time with a positive feedback
I hope so too!
How did it go?
Thank you: this helped me set up a way to collect timesheets from employees. :-)
Glad it helped!
Mil gracias!! que buen tutorial , desde hace tiempo estaba buscando algo que fuera practico!
hi. can you do this using Excel? just wondering... thanks.
This doesn't work very well because the employee self reports the times they come in and out. A "Clock In"-"Clock Out" form will automatically put the times in. However each entry, being on a new line, prevents you from being able to calculate hours worked. I have searched and searched for a solution but can't find one.
How come the time format when I tried this was 24 hours? How do I change it to 12?
Great video btw!
Additional question, how do you link the entry to be recorded on the sheet that's provided for the specific user? For example, the one in your video, how do you automatically put the entry for Joe, Tim, and Bob when they enter their names on the form?
How can we create a username and password for each person to enter this form?
that no one can register anything for another
My question is, although this is a good tool for time tracking purposes and to formulate total hours for reporting, can this resource with the Google Sheets be used for accountability. I wish there was a way to set time parameters so that the employee only had certain time frames to enter their information. Fore instance, say they were to clock in at 4pm, but they show up at 5pm. They would still be able to clock in at 4pm. But if there were a way to set a time parameter, where there could only enter their data fifteen minutes before or after their initial shift start and end time?
I think my new video titled The Best Employee timesheet using NFCs helps with this problem! Check it out and let me know what you think. I know its not exactly what you are looking for but I hope its usable solution.
Do you have to create a new form off the spreadsheet for each employee?
This method makes it so that you use a new form for each employee.
Is it possible somehow to automatically populate info in to Google time sheet from a "punch in or scan device " ?
Hey Misha! This was a hard one to crack but I think I figured out a way to do exactly what you want. Check out my newer video that goes over how to use an NFC to use as a swipe card on a dedicated device. Thanks!
Means if there is work start at midnight and finish otherday morning how formulas
The formulas should still work in counting the total hours.
what if we need to deduct lunch time?
You could add either two columns for time out for lunch and then time in for lunch. The subtract the total hours by the lunch time or you could have them just fill out time taken off for lunch and subtract that from the total time
Too much background noise!