• Something like this:

    SELECT *

    FROM

    (SELECT 1 as PersonID, '2016-10-21 11:00' as evntTime, 'CLOCK_IN' as evntType

    UNION ALL

    SELECT 1, '2016-10-21 20:45', 'CLOCK_OUT'

    UNION ALL

    SELECT 1, '2016-10-22 3:45', 'CLOCK_IN'

    UNION ALL

    SELECT 1, '2016-10-22 12:45', 'CLOCK_OUT'

    UNION ALL

    SELECT 2, '2016-10-23 11:00', 'CLOCK_IN') x

    WHERE x.evntTime > GETDATE()-1;

    You may need to tweak the WHERE clause so it returns exactly what you want.