Hi Rick,

With the help of the security seminar i made a login screen which also acts like a punch time card for an employee. There is also a log-out button.  Both the login and logout are automatically recorded in the TimeSheetT with the time, date and employee name. Watching the Work Order seminar, you show us how to do a calculation to find the hours worked.  

How can i calculate the number of hrs worked if both the login and logout time and date are in the same table and we take an hour lunch from 12-1pm?

- Will

---

Reply from Richard Rost:

What does your table look like? Is it:

ID, LoginTime, LogoutTime
1, 1pm, 3pm
2, 1pm, 4pm
3, 2pm, 6pm

or:

ID, Status, TimeDate
1, IN, 1pm
2, OUT, 3pm
3, IN, 1pm
4, OUT, 4pm