Hi, How I can automatically calculate early and late minutes from the following list.
___________________________________
ID Name Date/Time Status Name
___________________________________
1 ABCC 26-12-20 8:14 In
1 ABCC 26-12-20 16:04 Out
2 ACDD 28-12-20 7:50 In
2 ACDD 28-12-20 15:58 Out
3 IJKL 28-12-20 7:45 In
3 IJKL 28-12-20 16:00 Out
___________________________________
ID Name Date/Time Status Name
___________________________________
1 ABCC 26-12-20 8:14 In
1 ABCC 26-12-20 16:04 Out
2 ACDD 28-12-20 7:50 In
2 ACDD 28-12-20 15:58 Out
3 IJKL 28-12-20 7:45 In
3 IJKL 28-12-20 16:00 Out