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
From Pakistan, Peshawar
___________________________________
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
From Pakistan, Peshawar
@Salman
there must be any fixed time of entry and exit prescribed by the management, and based on that time frame (and relaxation allowed by management) only the early and late can be calculated, in absence of basic information the query is just mathematical riddle only, where all things are on assumption basis only
now a days finger tip or biometric attendance machines are popular, who calculate all these as per programs entered
630there must be any fixed time of entry and exit prescribed by the management, and based on that time frame (and relaxation allowed by management) only the early and late can be calculated, in absence of basic information the query is just mathematical riddle only, where all things are on assumption basis only
now a days finger tip or biometric attendance machines are popular, who calculate all these as per programs entered
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
SALARY SHEET CALCULATION.xls