Enter date and time

Hi All Members

Need Help to setup attandance report with time and date.

Thanks

Hi

I have some problem my "Employee Attendance Sheet” I want, when I put value A1"P" (Present) then
auto show current time if I put value "A" "Absent" not show time and if I put value "C" then not show time

Please help me?

Try This

=IF(A1="P",NOW(),"")

Just make sure you format your "Time" cell to display properly.

Originally Posted by elric411

Try This

=IF(A1="P",NOW(),"")

Just make sure you format your "Time" cell to display properly.

HI
I am very happy to you. But, it is not properly work when I put "P" it is show current time
But when I second time put the value "P" so all cell changes the time it is not correct I
Want when I put the value "P" then current show time ant stop it. When I second time put the
Value "P" automatically show the current time without another cell time changes

Thanks