Set up table / Count for workers attendance

Ask for Help
1

I would like to make Worker Salary section which calculate twice a month ( Every 2 weeks )

  1. Salary calculation based on my worker database which consist of one’s wage rate (per day) and OT rate (per day ) , this part everything going well when I link them by worker name
  2. I will make a form and let my worker to submit workers attendance every 8 pm (Full attendance (8 hrs + 3 OT) , Full day no OT ( 8 hrs ) or in case they absence )
  3. I want to count the total attendance of each worker , (First Monday of that month to second Saturday , I work 6 days a week )
  4. The table auto calculate from Worker wage database with total count attendance of 2 weeks ( 2 times a month)
  5. Please help me to set up table and how to count 2-week attendance , thank you
2

You should link them by a rowID or anything that’s unique. I don’t think names would guarantee to be unique.

Regarding your data structure, would there be any cases that a worker doesn’t work the full day, or doesn’t work the full 3 OT hours?

3

Yes , sometimes but rarely occur

4

So wouldn’t it be better to cover those cases if people have the chance to enter the “normal” hours that they work daily, and the “OT” hours, for every entry?