View Time Clock data for your team in StaffHub

Contributors: Diane Faigel
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.

  1. Sign in to StaffHub with your Office 365 work account, such as rob@contoso.com.

  2. Choose a team who is using Time Clock.

  3. Choose Settings.

  4. In the Time Clock section, choose Export.

  5. Enter the start and end date that you want to export. Click Export.

  6. At the bottom left of the page, click the spreadsheet to open it.

    Click to open the spreadsheet.

Understanding the Time Clock spreadsheet

Your Time Clock spreadsheet will look something like this sample:

A sample Time Clock spreadsheet.

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.

Sample Time Clock data for an employee

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.

Related Topics

Turn on Time Clock for your team in StaffHub

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×