Need to build a Macro to Manager Employee Breaks

Closed
Report
Posts
2
Registration date
Saturday July 11, 2015
Status
Member
Last seen
July 11, 2015
-
Hi

Need a macro to record and monitor break timings of employees on shift.

What I need is a Front End which will be each and every employee, who would login with numeric ids. It will have three buttons to record "tea break 1", "Lunch Break" and "Tea Break 2".

As soon as an employee clicks any button, it should capture start time and record it in a separate excel sheet which will be with manager, and the moment employee comes back from break he/she need to hit the same button to stop timer, so that break duration can be captured and populated on the master sheet which is with Manager.

Employee should not be able to alter times once its recorded.

Can anyone help me with the same