vmjamshad
11-09-2017, 05:10 AM
Hi, I am trying create attendance template using VBA. I managed to create one. But if I have a IN & OUT time on different dates (Example - In on 9/11/2017 8 PM and OUT on 10/11/2017 8 AM) i am not able to get it proper. Here I want a code to work on both (IN & OUT on the same day and IN & OUT on different dates). Please see the attendance data below:
Date & Time
Transaction Type
03/01/2016 8:38
I
03/01/2016 18:36
O
04/01/2016 8:12
I
04/01/2016 17:23
O
06/01/2016 8:14
I
06/01/2016 19:17
O
07/01/2016 20:00
I
08/01/2016 10:02
O
10/01/2016 8:22
I
11/01/2016 19:51
O
13/01/2016 8:22
I
13/01/2016 19:51
O
Date & Time
Transaction Type
03/01/2016 8:38
I
03/01/2016 18:36
O
04/01/2016 8:12
I
04/01/2016 17:23
O
06/01/2016 8:14
I
06/01/2016 19:17
O
07/01/2016 20:00
I
08/01/2016 10:02
O
10/01/2016 8:22
I
11/01/2016 19:51
O
13/01/2016 8:22
I
13/01/2016 19:51
O