Export Attendance Data as a Spreadsheet

To export a worksite Attendance Register as a spreadsheet:

1) Click Attend on the project list

 

2) Click Attendance History

 

3) Click the excel icon to export the data as a spreadsheet

 

4) The data will need to be formatted to show Arrival / Departure time

Highlight the Arrival & Departure Columns

Right Click and select Format Cells...

 

 

5) Select the Custom category and use the type:

d/mm/yyyy h:mm AM/PM

Click OK to update the spreadsheet