Good day All
Hope that you can assist.
Below is a example of customer visit data from one of our sales reps.
| Acc no. | Acc Name | Visit No. | Start Time | End Time | Duration |
| 112233 | ABC Store | V0001 | 2022/06/28 11:30 | 2022/06/28 12:00 | 30 |
| 445566 | XYZ Store | V0002 | 2022/06/28 11:50 | 2022/06/28 12:30 | 40 |
| 100025 | Happy bar | V0003 | 2022/06/28 13:00 | 2022/06/28 14:00 | 60 |
| 20564 | Sad Bar | V0004 | 2022/06/28 13:10 | 2022/06/28 13:50 | 40 |
| 5680 | ALTYX | V0005 | 2022/06/28 13:20 | 2022/06/28 13:30 | 10 |
The problem that I have is that the system allows multiple calls to run concurrently, this may be due to a Sales Rep forgetting to log out of a visit before starting a new visit.
Please assist me to get to the below result.
| Acc no. | Acc Name | Visit No. | Start Time | End Time | Duration |
| 112233 | ABC Store | V0001 | 2022/06/28 11:30 | 2022/06/28 11:50 | 20 |
| 445566 | XYZ Store | V0002 | 2022/06/28 11:50 | 2022/06/28 12:30 | 40 |
| 100025 | Happy bar | V0003 | 2022/06/28 13:00 | 2022/06/28 13:10 | 10 |
| 20564 | Sad Bar | V0004 | 2022/06/28 13:10 | 2022/06/28 13:20 | 10 |
| 5680 | ALTYX | V0005 | 2022/06/28 13:20 | 2022/06/28 13:30 | 10 |
