Forum Discussion
Excel time and date
Time Sheet
Report regular and overtime hours worked with this simple timesheet template. Perfect for small businesses, contractors, or the self-employed, this Excel timesheet template records time in, time out, and lunchbreaks for each day of the work week. As a timesheet in Excel, the total hours, regular hours, and overtime hours are automatically calculated. This timesheet template can also help you track the efficiency and productivity of teams within your company or business unit. This is an accessible template. Excel.
If you want something specific, then I recommend you to insert a specific file (without sensitive data). Explain your plan on the basis of this file.
Thus, you will be offered help in response to your needs.
Thank you for your patience and understanding.
If the template link from Microsoft helped you, Please Mark and Vote if it helps, as it will be beneficial to more Community members reading here.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- NikolinoDE
Thank you very much for your reply and examples.
I have attached the file that you’ve made, I hope it explains what I am trying to do better?
The last bit I need to try and understand/make work is the Overtime Profile table. I would like it to calculate if an employee has claimed overtime based on the time/date columns. Any hours after 17:00-00:00 Monday to Friday are at x1.5 basic rate and 00:01-08:30 are at x2 basic rate.
I am trying to have this Overtime Profile table so that it makes payroll easier and takes the thinking out of totalling up hours.
Many thanks,
Paddy- Sorry that should read, “I have attached the file that I’ve made”
