Overtime Calculator

Work Week

• Day: Day of the week acronym starting from Sunday to Saturday.
• Start (Time): Beginning of workday in the 12:00 [AM/PM] hour work format. Drop-down available.
• End (Time): End of a workday in the 12:00 [AM/PM] hour work format. Drop-down available.
• Work Period (Time): Automated formula that calculates the number of hours between End and Start (Time) assuming there is data available on both cells.
• Lunch: Amount of time spent on lunch break. Drop-down available.
• Add’l Break: Additional break incurred throughout the work period. Drop-down available.
• Time Worked: Formula that subtracts lunch and add’t break from work period assuming there is that available in the work period.

Key Results

• Avg Work Period: Average hours per work period.
• Total Work Period: Total amount of hours related to the work period.
• Avg Lunch Break: Average length of lunch break throughout the week.
• Total Lunch Break: Total number of hours spent in the lunch break.
• Avg Add’l Break: Average additional break throughout the week.
• Total Add’l Break: Total number of hours spent in additional break.
• Avg Time Worked: Average time worked throughout the week
• Total Time Worked: Total time worked throughout the week.

               In the sample provided, the average time worked is treated as 8, which could be expected in Canada for example. Yet, once we look at the total time worked, it becomes clear that extra hours were spent on a 6^th day, likely taking you to OT hours.

Time Worked Graph

               Provides a visual cue regarding the time worked throughout the week, helping to understand changes and discrepancies in workdays.