hi all

i have a large excel sheet full of login/logout times and wish to filter users who login late based on the time criteria in cells O1, there are various times listed throughout the day so say 4 instances of one name eg:

john doe 08:00:00 09:02:00
john doe 09:22:00 13:00:00
john doe 13:36:00 15:00:00
john doe 16:00:00 16:52:00

so login 0800, login 0902 logout 0922 etc.. through to last logout of 16:52

on the agents page i have the big list

on the filtered list i need to list only people who login late after 08:00 but before 09:00, then from 09:00 to 10:00 etc.. between these times i can use cond formatting to flag in red, i think im nearly there but im struggling with getting the correct agents as above. also ive noticed the date issue where it will keep looping to day 2, is there a way to set today from 08:00 to say 21:00 and filter only for that period.

ive upload a sheet as im not professional wandered if theres a less messy and simpler approach.

database1.xlsx