Cloudpainter
New Member
- Joined
- Jul 7, 2014
- Messages
- 6
Hello,
I'm creating an simple employee time-sheet and I want to calculate overtime.
The thing is I don't want it to calculate overtime when the person have worked ceraint amount of hours (in example: a person have a regular of 8hour work day, he works from 7am to 5pm making it 10 hours of work, therefore 10-8 = 2 hours of overtime)
I want it to start calculating overtime after a specific clock time (in example: a person have a regual of 8hour workday, he works from 7am to 5pm, his shift ended at 3pm, there for 5pm - 3pm = 2hours overtime)
The reason I want this is because the employees can stamp several task in one day, example:
Monday - Planted some flowers 7am - 10am = 3 hours total work
Monday - Watered some flowers 10am - 2pm = 4 hours total work
Monday - Cleaning the shed 2pm - 4pm = 2 hours total work
If this persons regual shift ended at 3pm he would be having 1hour overtime on this Monday
I'm creating an simple employee time-sheet and I want to calculate overtime.
The thing is I don't want it to calculate overtime when the person have worked ceraint amount of hours (in example: a person have a regular of 8hour work day, he works from 7am to 5pm making it 10 hours of work, therefore 10-8 = 2 hours of overtime)
I want it to start calculating overtime after a specific clock time (in example: a person have a regual of 8hour workday, he works from 7am to 5pm, his shift ended at 3pm, there for 5pm - 3pm = 2hours overtime)
The reason I want this is because the employees can stamp several task in one day, example:
Monday - Planted some flowers 7am - 10am = 3 hours total work
Monday - Watered some flowers 10am - 2pm = 4 hours total work
Monday - Cleaning the shed 2pm - 4pm = 2 hours total work
If this persons regual shift ended at 3pm he would be having 1hour overtime on this Monday
