Compare Time

Compare 2 times (each stored in variables) and determine whether one is before, after, or equal to the other.

Each time parameter (hour, minutes, seconds) must be stored in its own variable. Therefore, when using this command, you are working with a total of 6 variables – 3 variables for each of the 2 times being compared.

To learn more about the correct formats for these variables, see A NOTE ABOUT FORMATTING.

  1. For the first of the 2 times to be compared: Enter the names of the variables in which each of the individual time parameters is stored.

  2. For the second of the 2 times to be compared: Enter the names of the variables in which each of the individual time parameters is stored.

  3. Select whether you'd like to check if the time in column 1 is before, after, or equal to the time in column 2.

  4. Enter the name of the variable into which you'd like to place the result. (The result will be either TRUE or FALSE, as applicable.)

  5. Instruct the wizard how to handle any errors encountered. Read more about error handling.

Your HR department needs to provide management with a report of all employees who clocked in late for their scheduled shift. You can use the compare time command to compare whether the shift start time is before the clock-in time for each employee and use this data to prepare a report listing all employees for whom this comparison is TRUE.