README.md

metadata

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.