Overtime Calculator

Upload attendance Excel file → Calculate automatically

Upload Attendance File

Drop Excel file here or click to browse

Supports .xlsx files with attendance data

Eligible Positions for Overtime

Apoteker
Tenaga Teknis Kefarmasian
Branch Manager
Customer Executive
Health Advisor

Important: Only employees in the above 5 positions are eligible for overtime calculation. Other positions will show Rp 0.

Payment Tier System

No Payment
< 10 hours OT
Rp 0
Tier 1
10-12 hours OT
Rp 20,000
Tier 2
> 12 hours OT
Rp 40,000

Formula: OT Hours = (Check Out - Check In) - 0.5 hour break