Staff Time & Attendence Tracking

[chinni09]

Hi !! Everyone !!

i would like to create an excel, where i can capture inn time and out time of the staff movement. the system must be as such that if a person log inn with his/her ID card the system has to capture the inn time sententiously and out time when he/she logs out for the day...... In the attachment file...as soon as the ID no. is punched the inn time has to be captured.....at the end of the day the when the person scan the ID card his out time has to be capture.....

I have hands on excel but not good at VBA or macros...i have tried =now() formula but it keeps on updating as per the system time. I need a time stamp instead.....

Please help out...hope the attachment file gives you an idea....

[TMS]

I have updated your sample workbook. It should do most of what you want; see the notes on the Master worksheet.

Please see the attachment.

Regards

[chinni09]

First of all Thanks for support !!

In the attachment sheet, once the ID has been scan the excel file has to capture the system date and time of that movement ( irrespective to the no of movement), but if you see the sheet, i have put few ID (Which were available in master sheet) but system is only capturing the data of design, name of emp. etc. but not the time and date of ID scanned.

By this it helps me to capture data of month or a week and by this i can track out who is coming what time to office and who working late hours........

Awaiting for your reply.....

[chinni09]

Hi !!

This is me again...pls ignore my earlier comments.....The sheet is almost close to my requirements.... the only thing need to update is that....in column "H" need to be updated when the ID is re-punched in column "J" (Pls go through the attachment once)....

and 2 more requirements has pope up, 1st one is that when ID is scanned....the cursor has to move downwards for next scan.....

2nd one is that, i need to extract data basing up on date range or by name of person or by caterg. or by designation so that i would be easy for analysis.....if you can create a pop up screen for extracting such report would be a great help....

if you could help me out.....me experiment of create a template will be complete which i am trying to do for last 3 months.....

[tigertiger]

I assume you need a value for stamp time, you can assign it to value, such as

Change the code

    With Target.Offset(0, 1)
        .Value = Now()
        .NumberFormat = "dd/mm/yyyy"
    End With

to:

    With Target.Offset(0, 1)
        .Value = Now()
        .NumberFormat = "dd/mm/yyyy"
        .Value=.Value
    End With

Only add code-line: .Value=.Value

Plz do the same for others

[TMS]

You don't need

.value = .value

The code assigns the value of Now() to the cell, not the formula, so it is already a time stamp.

Had I said,

 .Formula = "=Now()"

you would be correct.

Did you test it out or have you made an assumption?

Regards