Ahh yes that's it. I was grouping by the wrong column. Thank you.

Thanks for the input everyone, I'll have to look into that.

Yes, they can do all of those. So that is also something I'd eventually like to take into account in my query.

Min and max have temporarily worked, but only if the person clocked in and out on the same day. And currently I just needed the results for a single...

Sorry about the cluttered table. I had the fields more spread out when I was typing it and it didn't quite look like that. I should have previewed it first....