Hello everyone,
I am a just learning macros and I would like some help in calculating the amount of time a person has worked.
Below is the raw data from a turnstile and I'd like to run a macro that spits out the person's name and teh minutes they worked.
For example, I'd like the output to be "MURPHY, EDDIE" 302 MINUTES.
Thank you for your help in advance.
I am a just learning macros and I would like some help in calculating the amount of time a person has worked.
Below is the raw data from a turnstile and I'd like to run a macro that spits out the person's name and teh minutes they worked.
For example, I'd like the output to be "MURPHY, EDDIE" 302 MINUTES.
Thank you for your help in advance.
| Message Text | Message Date/Time |
| Admitted 'MURPHY, EDDIE' (Card: 458638) at 'TURNSTILE IN[GA]' (IN) ([Unused]). | 1/25/2021 0:00 |
| Admitted 'SAM, SMITH' (Card: 457346) at 'TURNSTILE OUT [GA]' (IN) ([Unused]). | 1/25/2021 0:01 |
| Admitted 'MURPHY, EDDIE' (Card: 45836) at 'TURNSTILE OUT [GA]' (IN) ([Unused]). | 1/25/2021 5:02 |
