Workshop & business documents
Attendance Sheet With Overtime Calculation
This sheet records attendance for workshop and site staff: date, worker, role, status, time in and out. Set the standard day and unpaid break, and it works out hours, overtime and pay from each worker’s daily wage and overtime rate, with totals.
- Free, no sign-up
- Runs in your browser
- Built for Islamabad & Rawalpindi
This free calculator runs in your browser and needs JavaScript. If it does not load, call or WhatsApp us on +92 304 2435577 and we will do the calculation for you.
Disagreements over overtime are common when hours are not written down. A daily record that both sides can see avoids them.
What This Tool Does
It handles half days, absence, leave and shifts past midnight, and prints or exports the sheet.
Who It Is For
- Workshop owners.
- Supervisors.
- Site managers.
How To Use It
- Set the standard hours and break.
- Add each worker’s day.
- Review totals and print for signature.
How The Calculation Works
Hours = time out − time in − break. Overtime = hours − standard day. Pay = daily wage (half for a half day) + overtime × rate.
Worked Example
8-hour day, 60-minute break; a welder from 8:30 to 19:00 at Rs 2,500 a day and Rs 350 an hour overtime.
| Input or result | Value |
|---|---|
| Hours | 9.5 |
| Overtime | 1.5 hours |
| Pay | Rs 3,025 |
Totals add up across workers.
Features And Benefits
- Overtime automatically.
- Pay totals.
- Printable.
Assumptions And Accuracy Limits
- Not a payroll or tax system.
- Records stay in your browser on your device; nothing is uploaded. Download a backup regularly.
Common Mistakes To Avoid
- Forgetting breaks.
- Recording later from memory.
- No signature. Have workers sign the printout.
Workshop Staff In Islamabad And Rawalpindi
Workshop staff in the twin cities are commonly paid daily wages with overtime. Ramzan Steel Works keeps attendance records for its team.
Frequently Asked Questions
How do you calculate overtime?
Hours worked minus the standard day, multiplied by the overtime rate.
Is the break counted?
Set the unpaid break; it is subtracted from hours.
Can it handle night shifts?
Yes, a time out earlier than the time in counts as the next day.
Related Free Tools
- Daily Production LogLog daily output by job and stage, man-hours, output per man-hour and rework.
- Welding Job Cost, Labour & Overhead EstimatorBuild a welding job price from materials, labour, consumables, overheads and your margin.
- Fabrication Project Task TrackerTrack tasks for each job with owner, due date, status and priority; overdue tasks highlighted.
- Machine Utilisation & Downtime TrackerUtilisation and availability by machine, with downtime totals by reason such as load-shedding.
Get A Measured Quotation
Ramzan Steel Works runs a skilled workshop team in Islamabad and Rawalpindi.
