Hi All,
I have a report which shows clock in and out times for staff members. This literally shows every time they clock in/out during the day, but what I want to do is easily find just the first and last clock in/out.
The below link shows an example of the data.
https://drive.google.com/file/d/1dI8N-0OG3ixzd6veqbpDrzuRdWAR8_Lw/view?usp=sharing
Please can someone help either with a formula or VBA code?
Thanks,
Chris
I have a report which shows clock in and out times for staff members. This literally shows every time they clock in/out during the day, but what I want to do is easily find just the first and last clock in/out.
The below link shows an example of the data.
https://drive.google.com/file/d/1dI8N-0OG3ixzd6veqbpDrzuRdWAR8_Lw/view?usp=sharing
Please can someone help either with a formula or VBA code?
Thanks,
Chris