Time Sheet?

[oogles36]

I have a list of Clock in and Clock outs. Its formatted like this:

Column A : Employee Name
Column E: Date and time in this format: May 16, 2023 10:21:14 PM
Column F: On (for an on punch or Off for a clock out)

The list I have is about 150k rows....

I'm trying to find a formula or a way to just see employees that clock in with less than 10 hours off.

So if you clocked out May 16, 2023 at 10:21:14 PM and then clock in May 17, 2023 at 01:14:14 AM you would be flagged somehow...

 

[jorismoerings]

Your screen shot shows a merged cell with the name. The check in the IF formula will only work if you repeat the name on each line.