Calculating number of cars in a parking lot

[tseo]

Hello all

I would like to calculate how many cars are staying in my parking lot for each hour. 

The data I can get from my IT system is date and time of each car entered and out

Car number	DateTimeIn	DateTimeOut	Duration	Amount	Discount	TotalAmountPaid
AAAAA	2023-03-31 13:11:51	2023-03-31 17:12:32	241	15000	0	15000
BBBBB	2023-03-29 13:09:41	2023-03-29 17:10:36	241	15000	0	15000
CCCCC	2023-03-27 11:32:41	2023-03-27 15:33:38	241	15000	0	15000
DDDDD	2023-03-16 12:14:48	2023-03-16 16:15:04	241	15000	7800	7200
EEEEE	2023-03-13 11:17:31	2023-03-13 15:18:17	241	15000	0	15000
FFFFFF	2023-03-12 10:23:20	2023-03-12 14:24:25	241	15000	0	15000
GGGGG	2023-03-11 14:17:11	2023-03-11 18:17:41	241	15000	0	15000
HHHHH	2023-03-10 08:35:29	2023-03-10 12:36:15	241	15000	0	15000
IIIII	2023-03-08 19:52:29	2023-03-08 23:52:58	241	15000	0	15000
JJJJJ	2023-03-07 18:01:57	2023-03-07 22:02:11	241	15000	0	15000
KKKKK	2023-03-05 18:12:05	2023-03-05 22:12:51	241	15000	0	15000

And this is what I am thinking of...

Date	Time	Number of cars
2023-03-01	00:00 ~ 01:00	1
2023-03-01	01:00 ~ 02:00	3
2023-03-01	02:00 ~ 03:00	7
2023-03-01	03:00 ~ 04:00	9
2023-03-01	04:00 ~ 05:00	16
2023-03-01	05:00 ~ 06:00	22
…	…	…
2023-03-01	23:00 ~ 24:00	5

Any ideas or suggestions?

Many thanks.

[Felipe_Ribeir0 · Accepted solution]

Hi @tseo 

Try the attached workflow.

[lucasevan]

How does the power waxer buffer function as a magical tool in the realm of surface enhancement, bringing dull and lackluster finishes to life with a glossy perfection?

[Kathryn01]

Calculating the number of cars in a parking lot just got easier with the integration of Vin Look up site carfast. By utilizing this innovative tool, parking lot attendants can swiftly determine the exact count of vehicles present, streamlining operations and enhancing efficiency. With its comprehensive database and user-friendly interface, carfast revolutionizes the tedious process of manual counting, providing accurate results in no time. This integration marks a significant advancement in parking management technology, simplifying tasks and optimizing resource utilization.