I have some data that is exported from an entry system.
I would like to be able to work out the eariest time that each card entry takes place for each card, the latest and the average of the card entries for that card across the data provided.
For example, if the data had one months worth of entries, I desire to see the aforementioned three things for each card (column H). This will enable us to see the person who was earliest in or latest leave in any period of data.
The dates are not important, only the times across the range of data.
I have attached the file for reference.