Skip to main content

Identify Jobs Below Minimum Time - Attendance Report

Use filters in Excel to find shifts that are shorter than your minimum job time, helping you spot potential issues.

B
Written by Brett Sansom

How to identify short shifts

To identify short shifts follow the steps below:

  1. Locate the Actual Hours column (e.g., column N).

  2. Click the filter and choose Number Filters > Less Than.

  3. Enter your minimum time in decimal (e.g., 0.5 for 30 minutes).

This will highlight all shifts shorter than your threshold.

⏱️ Use this to ensure compliance with minimum shift durations.


πŸ€“Tip: Why not take a look at the full Attendance Report guide attached below.


Need More Help?

If you're still having trouble, feel free to contact support with the details mentioned above. We're here to help!

Did this answer your question?