Weekly Hours Calculator
Employee hours from card reader exports
Load the XLSX export, choose a Monday-based week, review the schedule and weekly targets, then calculate, correct missing punches, and export the report.
1. Load file
The parser expects the same layout as example_file.xlsx, with real data starting on row 9.
Valid swipes
0
Rejected rows
0
Available weeks
0
Choose a file to begin.
2. Week and targets
Weeks start on Monday. You can also exclude names or IDs and set per-employee weekly hour exceptions.
Schedule total
40:00
3. Schedule
These times are used to display the planned day shape and distribute the weekly target through the week.
| Day | Start | End | Planned |
|---|---|---|---|
| Monday | 08:30 | ||
| Tuesday | 08:30 | ||
| Wednesday | 08:30 | ||
| Thursday | 08:30 | ||
| Friday | 06:00 | ||
| Saturday | 00:00 | ||
| Sunday | 00:00 |
Results
The printable report uses the summary table below. Expand an employee to correct day punches manually.
| Employee | ID | Hours to do | Hours worked | Balance | Review |
|---|---|---|---|---|---|
| Load a file and click calculate. | |||||