hi, i want to make a simple time keeping project - it would calculate worked hours semi-monthly using the following rules:
- first 8 hours Mo-Sa as regular time is less than 40 per week, if over 40 hours Saturday is overtime (if there is a statutary holiday 32 hours a week as regular time)
- 9 to 12 hours as overtime
- over 12 hours as double time
- for Sunday first 12 hours as overtime, rest as double time.
this is not a homework
i work as an accountant for a fishing lodge (seasonal staff) and i don't want to calculate it manually from excel spreadsheets i receive semi-monthly.
i am looking for some hints - can i just use 'weeknum' and 'weekday' function in queries or should i take different approach?
thanks
- first 8 hours Mo-Sa as regular time is less than 40 per week, if over 40 hours Saturday is overtime (if there is a statutary holiday 32 hours a week as regular time)
- 9 to 12 hours as overtime
- over 12 hours as double time
- for Sunday first 12 hours as overtime, rest as double time.
this is not a homework
i work as an accountant for a fishing lodge (seasonal staff) and i don't want to calculate it manually from excel spreadsheets i receive semi-monthly.i am looking for some hints - can i just use 'weeknum' and 'weekday' function in queries or should i take different approach?
thanks