ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to create Login & Log out Spread sheet in Excel with automated Attendance sheet (https://www.excelbanter.com/excel-worksheet-functions/266034-how-create-login-log-out-spread-sheet-excel-automated-attendance-sheet.html)

marc5354

How to create Login & Log out Spread sheet in Excel with automated Attendance sheet
 
Hello Friend

Can anyone please help me, how to activate attendance sheet automatically if officer get logged in office. Like there are 100 PA (Process Asso.) in an office in various Department. If they are logged in Morning with their login Name, they got present for the day in attendance sheet automatically, and if PA got Absent for the day in attendance sheet automatically as i mentioned. And weekend(s) like Saturday and sunday is holiday.

Marc

wickedchew

Quote:

Originally Posted by marc5354 (Post 959632)
Hello Friend

Can anyone please help me, how to activate attendance sheet automatically if officer get logged in office. Like there are 100 PA (Process Asso.) in an office in various Department. If they are logged in Morning with their login Name, they got present for the day in attendance sheet automatically, and if PA got Absent for the day in attendance sheet automatically as i mentioned. And weekend(s) like Saturday and sunday is holiday.

Marc

Try this link:

http://www.ozgrid.com/forum/showthre...t=67112&page=1

marc5354

Thank you wickedchew

I check above given link, but it doesn't help in my way.

Marc


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com