Simone_1974
New Member
- Joined
- Apr 22, 2016
- Messages
- 1
Hi there guys. I work for a company that is hectic on time. I need a formula that will work out the following:
1) Hours worked
2) If lunch was taken, but not the full hour, that time does not count as overtime or time due to the employee, that time is gone.
3) if you come back late from lunch, you owe the company that time.
So it will basically have a worksheet for every employee (about 8 of us). Date, Time In, Lunch Out, Lunch In, Time Out, Total hours worked, Time Owed To Company or Time Owed to Employee
Where we get stuck every time is if someone comes back late from lunch or doesn't take the full hour lunch, it stuffs out the formula. How do I do this? Thanks in advance.
1) Hours worked
2) If lunch was taken, but not the full hour, that time does not count as overtime or time due to the employee, that time is gone.
3) if you come back late from lunch, you owe the company that time.
So it will basically have a worksheet for every employee (about 8 of us). Date, Time In, Lunch Out, Lunch In, Time Out, Total hours worked, Time Owed To Company or Time Owed to Employee
Where we get stuck every time is if someone comes back late from lunch or doesn't take the full hour lunch, it stuffs out the formula. How do I do this? Thanks in advance.
