• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Time Sheet

A

amit_gupta123

Member
Hi

i am looking for a formula through which a time sheet of employee sign and sign out can be created. idea is when the employee enter the premises he will punch his employee code say 1101 and the current time of the system get punched automatically and further this time does not chage with the change in time of system. a daily report of such sign in and sign outs may be generated. I want to use excel formulas but when i try time changes as the system time changes
 
Does Chandoo's post here help?

http://chandoo.org/wp/2009/01/08/timestamps-excel-formula-help/


Otherwise, you might have to use an worksheet_change event macro to insert the time stamp.
 
You must log in or register to reply here.
Back
Top