Last updated 22 February, 2018
It's easy to see whether your employees are clocking in and out at the right time and location. You export and view the data in Excel! This way, you can sort through hundreds or thousands of employees quickly.
Sign in to StaffHub with your Office 365 work account, such as firstname.lastname@example.org.
Choose a team who is using Time Clock.
In the Time Clock section, choose Export.
Enter the start and end date that you want to export. Click Export.
At the bottom left of the page, click the spreadsheet to open it.
Understanding the Time Clock spreadsheet
Your Time Clock spreadsheet will look something like this sample:
The spreadsheet shows 1 row for every clock in/out pair for a firstline worker.
We’ve conveniently provided all the shifts that are scheduled on that day of the clock in/out. This makes it easy for you to compare the scheduled time to the actual clock in/out time.
For example, let's take a closer look at Time Clock data for Dorothy.
Row 2 shows that Dorothy clocked in at 7:03am and out at 11:30am during her 7-3pm shift.
Row 3 shows that she clocked in at 12:03pm and out at 3:20pm also during her 7-3pm shift.
Row 4 shows when she clocked in and out for her next shift on the following day.
What does FALSE mean?
When you turned on Time Clock, if you also selected Include location detection, your spreadsheet will have columns Clock In Within Distance Set and Clock Out Within Distance Set.
When an employee isn't within the set location when they clock in or out, a value of FALSE appears. If the employee was at the location and FALSE appears incorrectly on your spreadsheet, we recommend using the GPS coordinates for your location instead of the address. It's more precise. However, due to a wide range of quality among mobile device GPSes, the precision of the location signal can vary.