Forum Discussion
Solved
Important formula in Excel
Hello, We have a license plate, entry, exit date and slot limit. I need to calculate who enter the parking when there was no space e.g two cars inside parking, third one has enter as "overslot" a...
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".
Hello,
Thank you. It's exactly what I'm looking for and it's seems I need to study about "Power Query"..
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.