BERVES ENGINEERING — SITE OPS TOOLING

Clock Duration → General Timesheet

Upload a Clock Duration export (raw gate/biometric In & Out events) and convert it into a Berves-style weekly General Timesheet — Normal Hours and Overtime split by day, grouped by section, with a Summary tab.

1

Upload clock duration file

.xlsx export containing a raw clock event table (Employee ID, Surname, Initials, In, Out, Duration…).

⇪
Click to browse or drop an .xlsx file here
Only the sheet with In/Out clock columns is read — other tabs are ignored
2

Review period & assign roles

Designation and section aren't in the clock data — set them once per employee before generating.

No Tag No. Name Designation Section Days Total Hrs
3

Generate timesheet

Builds one sheet per week (Sun–Sat), an 8-hour daily normal-hours cap with overtime split, plus a Summary tab.