asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Good Day,
How can I get customers total time visit base on below table?
Many Thanks.
How can I get customers total time visit base on below table?
Many Thanks.
Customer ID | First Name | Last Name | Time In | Time Out | Customer ID | First Name | Last Name | Tot.Hrs. | |
12345 | xxxxx | xxxxxxx | 9:15 | 12:21 | 12345 | xxxxx | xxxxxxx | ? | |
12345 | xxxxx | xxxxxxx | 12:15 | 14:10 | 98765 | xxxxx | xxxxxxx | ? | |
12345 | xxxxx | xxxxxxx | 22:05 | 2:05 | |||||
12345 | xxxxx | xxxxxxx | 2:15 | 4:22 | |||||
98765 | xxxxx | xxxxxxx | 14:22 | 16:45 | |||||
98765 | xxxxx | xxxxxxx | 15:30 | 18:22 | |||||
98765 | xxxxx | xxxxxxx | 18:24 | 21:35 | |||||
98765 | xxxxx | xxxxxxx | 19:35 | 23:00 | |||||
98765 | xxxxx | xxxxxxx | 22:10 | 22:55 |