I'm trying to make my database keep track of employees' hours Of course, anything over 40 hours a week is overtime at 1.5x. Also, if 40 hours isn't actually worked (sick, vacation, etc.), it's at 1x. I'm not sure where to begin. I was thinking about a calendar to schedule someone's month and then weekly and also daily. I really don't know where to begin. I would like to begin by asking opinions on how to start this task. I need to keep track of how many hours worked, sick time and other leave types used. It needs to automatically calculate the rate of pay. I would really appreciate opinions on how to go about starting this.