Respected,
Can I have the solution like
when an employee enters his/her employee ID 1st time,
HARD coded date and time is entered in 2nd cell ,
2nd time , HARD coded time is entered in break start ,
3rd time then HARD coded time is entered in break end and
4th time HARD coded date and time is entered in day end
----------ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF
ROW1 Emp ID DAYstart Breakstart BreakEnd DayEnd calculate HH:MM depending on hours done
Zohar Batterywala