Hi All,
I am hoping someone can give me a bit of advice. I'm not sure how to do this:
Basic Info:
The application id for staff hours - the School has set times 08:00 till 17:00
If the Staff work outside of these hours they are awarded overtime
If they work after 21:00 (Parents evening) they get an extra bonus per Hour.
I have a table where the staff enter their hours. e.g.
Staff Id Date From Till
001 01/02/2016 08:00 17:00
001 01/02/2016 18:00 23:00
Now at the end of each month I would like to run a module/code that will
go through each record and add a record to another table/s noting on 01/02/2016 overtime of 4 Hours and bonus for 2 Hours for Staff member 001.
BUT hours like from 09:30 till 18:00 could also be entered. (1 hour overtime even though hours not exceeded but no bonus)
or 06:30 till 12:00 (1/2 hour overtime)
Hope this makes sense to someone
and that someone...anyone can offer a bit of advice or ideas how best to achieve this.
Thanks
Marion
I am hoping someone can give me a bit of advice. I'm not sure how to do this:
Basic Info:
The application id for staff hours - the School has set times 08:00 till 17:00
If the Staff work outside of these hours they are awarded overtime
If they work after 21:00 (Parents evening) they get an extra bonus per Hour.
I have a table where the staff enter their hours. e.g.
Staff Id Date From Till
001 01/02/2016 08:00 17:00
001 01/02/2016 18:00 23:00
Now at the end of each month I would like to run a module/code that will
go through each record and add a record to another table/s noting on 01/02/2016 overtime of 4 Hours and bonus for 2 Hours for Staff member 001.
BUT hours like from 09:30 till 18:00 could also be entered. (1 hour overtime even though hours not exceeded but no bonus)
or 06:30 till 12:00 (1/2 hour overtime)
Hope this makes sense to someone

Thanks
Marion