Need help with a lateness tracker.

I was asked to create a lateness tracking spreadsheet for my job. My previous one became too unwieldy so I am creating one from scratch but need some tips and tricks to make it easy to create.

What I need to do is for each of the 4 quarters (Jan-March) (April-June) (July-September) (October-December) is track how many minutes each employee is per day. When it hits 30 minutes the employee is required to submit a slip for half hour of personal time.

What is the best way to do this? Each employee name is entered on the Agent Info tab with a space between them.

I need to have this created by 12/30