datetime conversion
Posted: Fri Mar 09, 2012 12:18 am
Hi,
Currently im developing a payroll system now, but im getting a hard time how to calculate datetime from our attendance sheet (biometrics).. I do have connection to import our existing software which is our biometrics going to php mysql database. my problem is I do not have an idea how to calculate their attendance.
example
ID DEPARTMENT NAME EMPLOYEEID DATE/TIME
1 IT JON 100011 2012-04-02 06:00:00 aM
2 IT JON 100011 2012-04-02 06:00:00 PM
how do i manage their attendance or compute DATETIME field to get exactly salaries,
any ideas?
REGARDS ALL,
Currently im developing a payroll system now, but im getting a hard time how to calculate datetime from our attendance sheet (biometrics).. I do have connection to import our existing software which is our biometrics going to php mysql database. my problem is I do not have an idea how to calculate their attendance.
example
ID DEPARTMENT NAME EMPLOYEEID DATE/TIME
1 IT JON 100011 2012-04-02 06:00:00 aM
2 IT JON 100011 2012-04-02 06:00:00 PM
how do i manage their attendance or compute DATETIME field to get exactly salaries,
any ideas?
REGARDS ALL,