Forum Discussion
Help with calculating time ???
I'm very new to this.. I tried a couple of things...
Hello rf27
i tried to analyse your data withou success. Grouped by the two columns i got this examples (only with nulls)
| 03.12.2019 20:21:00 | Access Granted | 1443ASM POST 2 TS4 EXIT C03-P3-R1 | 24808 | 20600609 | 03.12.2019 17:21:00 | 03.12.2019 | 17:21:42 | Contractor | 0 |
| 04.12.2019 20:25:00 | Access Granted | 1443ASM POST 2 TS5 EXIT C03-P2-R1 | 24808 | 20600609 | 04.12.2019 17:25:00 | 04.12.2019 | 17:25:29 | Contractor | 0 |
| 05.12.2019 20:22:00 | Access Granted | 1443ASM POST 2 TS6 EXIT C03-P2-R2 | 24808 | 20600609 | 05.12.2019 17:22:00 | 05.12.2019 | 17:22:12 | Contractor | 0 |
for others only 1
| 03.12.2019 18:39:00 | Access Granted | 5014 ENT CSS CORREDIZA 3 C14-P6-R1 | 41691 | 301497 | 03.12.2019 15:39:00 | 03.12.2019 | 15:39:40 | Contractor | 1 |
| 03.12.2019 20:10:00 | Access Granted | 5014 ENT CSS TOR 4 RA C12-P3-R2 | 41691 | 301497 | 03.12.2019 17:10:00 | 03.12.2019 | 17:10:54 | Contractor | 1 |
| 03.12.2019 13:17:00 | Access Granted | 5014 ENT CSS CORREDIZA 2 C14-P7-R1 | 41691 | 301497 | 03.12.2019 10:17:00 | 03.12.2019 | 10:17:22 | Contractor | 1 |
| 03.12.2019 18:38:00 | Access Granted | 5014 ENT CSS CORREDIZA 2 C14-P7-R1 | 41691 | 301497 | 03.12.2019 15:38:00 | 03.12.2019 | 15:38:38 | Contractor | 1 |
| 03.12.2019 13:16:00 | Access Granted | 5014 ENT CSS TOR 1 RA C12-P0-R2 | 41691 | 301497 | 03.12.2019 10:16:00 | 03.12.2019 | 10:16:42 | Contractor | 1 |
| 05.12.2019 19:14:00 | Access Granted | 5014 ENT CSS TOR 3 RA C12-P2-R2 | 41691 | 301497 | 05.12.2019 16:14:00 | 05.12.2019 | 16:14:39 | Contractor | 1 |
Jimmy
