---
title: OT Calculator (P10/P20)
emoji: 🕒
colorFrom: indigo
colorTo: green
sdk: gradio
app_file: app.py
pinned: false
license: apache-2.0
---

Upload a 3-column file: employee, yyyymmdd, hh:mm:ss (or hhmmss).

Policy:
- Baseline cutoff: **17:30** before 2025-07-07; **17:00** from 2025-07-07.
- OUT gaps are subtracted from OT.
- Case 4 (already inside at cutoff): effective start is shown in `virtual_in_time`.

Output columns: `employee_id, date, ot_hours, code, in_times, out_times, virtual_in_time`.