Forum Discussion
Important formula in Excel
Papajus I'm not fully understanding your question, but perhaps the attached file helps. I pulled the table into Power Query and re-shaped it a bit. It should enable you to see entries and exits in chronological order. The first couple of rows look like this:
E.g. on the 28th, 6 cars entered between 9:08 and 10:46. When you say that you only have two slots, the last 4 were "overslot".
Papajus I'm not fully understanding your question, but perhaps the attached file helps. I pulled the table into Power Query and re-shaped it a bit. It should enable you to see entries and exits in chronological order. The first couple of rows look like this:
E.g. on the 28th, 6 cars entered between 9:08 and 10:46. When you say that you only have two slots, the last 4 were "overslot".
Thank you. It's exactly what I'm looking for and it's seems I need to study about "Power Query"..
Papajus Glad I could help. The site in the link below would be a good place to start.