Time Tracker For Team Members

[Abhishekghorpade]

Hi,

I am looking for a login and logout time tracker for my team. Below is what i have in my mind any better ideas are much appreciated.

1.When User Enter the Employee ID in Sheet 1 Page, it should fetch the name from "Sheet 2"(Data). More people will be added later
2. When LOGIN Button is pressed - it should display the Time (Once Login is pressed - Log In Button should be disabled)
3. When LOGOUT Button is pressed - it should display the Time (Once LogOut is pressed - Log Out Button should be disabled)
4. YOUR TOTAL LOGIN HRS FOR TODAY IS - when LOGOUT is pressed, it should display total hours spend on that day.
(NOTE: Other than Employee ID Text Box, all other Items should be disabled for editing for user)
5. Once Log In is pressed - Current Date, Employee Name, Login Time sould be saved in Report sheet. (Should not be editable)
6. Once Log Out is pressed - it should display the time in Logout Column. (Should not be editable)
7. If there is no Log in and log out it should mark in the report as Leave
8. If the total time is less than 7 hrs then it should take it as half day in the report.

If you have a ready templet or you have better ideas that’s also work fine for me.