Working Hours Register Program - Level 3: Weekly Aggregation and Overtime Calculation

Question

## Round 1 - Coding

## Problem

Building on your Level 2 register, add weekly reporting and overtime logic:

1. `get_weekly_report(emp_id, week_start)` — return a dict mapping each day of the week to total hours worked (0.0 if no sessions).
2. `get_overtime_hours(emp_id, week_start, regular_limit=40)` — return hours worked beyond `regular_limit` in that week, after merging overlapping sessions per day.
3. `get_top_n_employees(week_start, n)` — return the top N employees by total hours that week.

```python
class WorkHoursRegister:
    def get_weekly_report(self, emp_id: str, week_start: str) -> dict[str, float]: ...
    def get_overtime_hours(self, emp_id: str, week_start: str, regular_limit: float = 40.0) -> float: ...
    def get_top_n_employees(self, week_start: str, n: int) -> list[str]: ...
```

```
Input (week starting 2024-01-01, Mon-Sun):
  add_session("E1", mon, 8, 20)  # 12 hrs
  add_session("E1", tue, 8, 20)  # 12 hrs
  add_session("E1", wed, 8, 18)  # 10 hrs
  get_overtime_hours("E1", "2024-01-01") -> 0.0  # only 34 hrs
  get_weekly_report("E1", ...) -> {"Mon": 12.0, "Tue": 12.0, "Wed": 10.0, "Thu": 0.0, ...}
```

## Follow-ups

1. Some employees are part-time with a 20-hour regular limit. How do you store and use per-employee limits?
2. How would you handle a session that spans two calendar days in the weekly bucketing?
3. Design an alert: notify if any employee exceeds 12 hours in a single day. Where in your class does this check live?
4. How would `get_top_n_employees` scale to 10,000 employees and 52 weeks of history?

Working Hours Register Program - Level 3: Weekly Aggregation and Overtime Calculation

Question Details

Full Details

About This Question

Topics

More Codesignal Interview Questions