mummbles74
Board Regular
- Joined
- Nov 14, 2009
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
I have a list of gate times that are downloaded from a clients site access system, they want us to use these time to confirm our invoiced hours. There has been a system update and the data I receive is now in a RAW format and it creates an extremely manual task doing this for everyone on site. I have created some formulas to make it a little easier but there is still a large number of manual inputs that I need to do. Below is how I receive the data, this is the only required data from the 20 something columns. What I would like to be able to do and I have a feeling it is possible from reading some other posts is copy the earliest time from the day put it in a column of a new sheet and the latest time from the day in the next column so that I can then calculate the time.
Cardholder Transaction History Report
Cardholder Transaction History Report
Date (>=) | 01/02/2022 00:00:00 |
Date | 01/02/2022 06:22:13 |
Date | 01/02/2022 14:03:43 |
Date | 01/02/2022 14:56:44 |
Date | 01/02/2022 16:31:00 |
Date | 02/02/2022 06:21:51 |
Date | 02/02/2022 11:01:56 |
Date | 02/02/2022 13:59:47 |
Date | 02/02/2022 16:30:14 |