leesummer
09-27-2005, 02:11 AM
Dear All,
I want to build a database for time monitoring of employee. Record time and to compute for all overtimes. Right now i have a tables (Employee, TimeEntry). In Time Entry Table, I included the dates. How can i compute the total hours an employee goes overtime and undertime excluding sundays and holidays with a period of Bi-monthly.
Thanks in advance
I want to build a database for time monitoring of employee. Record time and to compute for all overtimes. Right now i have a tables (Employee, TimeEntry). In Time Entry Table, I included the dates. How can i compute the total hours an employee goes overtime and undertime excluding sundays and holidays with a period of Bi-monthly.
Thanks in advance