How to create Login & Log out Spread sheet in Excel

**moses4u** · 09-14-2010, 10:00 AM

Hello everyone, can anyone let me know how to create a Login & Log out Spread sheet in Excel.

Moses

**JBeaucaire** · 09-14-2010, 10:03 AM

A layout of any kind would be based on your needs. Based on all you've provided so far, I'd suggest simply:

Column A - Name (formatted as text)
Column B - Time IN (formatted as time)
Column C - Time OUT (formatted as time)

**moses4u** · 09-14-2010, 11:55 AM

are there any possibility to create it with userform(Macro)

**contaminated** · 09-14-2010, 11:58 AM

I created one for myself. just to learn VBA, a few months ago. Please take it. Passwords are 1, 2, 3 or 4.

**moses4u** · 09-14-2010, 01:39 PM

Thank you.

**moses4u** · 09-20-2010, 12:50 PM

Hello...

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.

Moses.