Construction attendance tracker
Collect text reports of worker presence, arrival, departure and breaks. Duration is calculated from reported times; missing replies and incomplete records stay visible.
Dina collects text replies for this format. Review the questions, respondents and schedule before starting.
No registration · fictional sample data · updated 10 September 2026Who is this for?
Site managers and field crew coordinators who need a view of reported attendance by worker and site.
A filled-in example
| Respondent | Shift date | Site | Worker | Reported presence | Arrival | Departure | Break minutes | Calculated hours |
|---|---|---|---|---|---|---|---|---|
| Anna Example | 2026-09-17 | North | Alex Example | Reported present | 2026-09-17 22:00 | 2026-09-18 06:00 | 30 | 7.5 |
| Igor Example | Not reported | Not reported | Not reported | Not reported | Not reported | Not reported | Not reported | Not reported |
Fictional sample data. Missing answers are shown separately from confirmed zero values. The downloadable workbook contains the full set of fields.
What the spreadsheet tracks
- Worker and shift
- Give the shift start date, site, worker name and trade. A supervisor can report several workers.
- Full dates and times
- An overnight shift needs the following date and a time zone. Missing or inconsistent time entries do not produce a duration.
- Reported presence
- Each entry records what the respondent said. Photo or location verification of physical presence and payroll calculations are not included.
Questions for collecting the data
- Which date and site are you reporting on? List workers and trades, and state whether each person was present or absent.
- For each person present, give full arrival and departure dates and times with a time zone, plus break minutes. An overnight shift needs the next date.
- Which records need clarification? Explicitly say if no workers attended. These are text reports, not location or photo verification.
These are the live format’s standard questions. Replies, clarifications and source messages remain available in the app.
How to use the template
Choose the format
Review the standard questions. For project tasks, import and check the register and owners first.
Invite respondents and set the schedule
Choose email or another connected channel, collection days, response deadline and report recipients.
Review the collected result
Check missing information and original replies, read the summary and download the frozen Excel report.
This workbook shows a completed collection, not a form for respondents to fill in. Import a reviewed register for project tasks. Participants answer other formats in text.
Questions about this template
How is an overnight shift calculated?
The full arrival time and explicitly stated break are subtracted from departure. A 22:00–06:00 next-day shift with a 30-minute break gives 7.5 hours.
What if a worker has not reported departure?
Duration stays blank and Dina requests clarification. A missing departure is not replaced with the end of the working day.
Are these verified attendance or payroll hours?
No. They are calculated from text reports. Attendance verification, rates, wages and payment rules are outside this format.
Put the template to work
View the English example and set up collection with your team. Check the report recipients before sending.