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.
