Can anyone please assist me in composing a macro to capture the break timing of my team members. Am desperately in need of this macro to capture their break timing as this would reflect in my appraisal.
It would be helpful and greatful if anyone could assist me on this.
I have listed down the points on how the macro should run.
1) I need a macro to capture the start time and end time of the employee.
2) I would have two command buttons, one with start time and other with End time.
3) When i click on the Start time command button, it should prompt for a input box to enter the employee number. When i enter the employee number, it should go the particular cell where the employee number is available and should capture the start time in the cell which has the start time field. (Same opertaion should be performed for end time command button also)
4) An employee should be able to capture the start time and end time only once in a day. He should not be able to re-enter it. If anyone wants to change it, then it should be only if the person knows the password. (This is because to avoid the employee entering the duplicate shift timing)
5) The start time should be entered based on the system date. For example if am present in the office today and am going for a break now and if i clcik on the start time button, It should capture the time in the cell with the current date. This macros should not allow the employees to capture time for back dated or for future dated. (backdated and future dated action can be performed only if the person know the password)
6) As soon as the time is captured by the employee spreadsheet should be saved automatically and it should not allow them to enter the time once again. (for eg: if i click on start time and it is captured in the cell which has current date, spreadsheet whould be saved automatically and if i click on the start time again it should not allow me to capture the start time again)
7) When the start time and end time is captured. Both the time should be subtrated and the difference of minutes should be captured in the time taken cell. (This is to monitor the minutes the employee has taken break)
8) A single spreadsheet will be maintained for a particular month. (for example: I would maintain a single spreadsheet for themonth of august). [this would be as (cell c will have start time, D will have end time, E will capture the time taken minutes-> this will be for the Date August 1st].
Again for August 2nd. Start time will be in cell F, end time in Cell G, time taken in cell H. Same the way it will be for the other dates too.
Please assist me in preparing the macto with the above criterias. This is really going to help me in my promotion and appraisal. I would be thankful to you if you can look into this at the earliest and provide me with the solution.
I have updated the template of my spreadsheet below.
Employee# Employee
Name 20-07-2011 21-07-2011
StartTim EndTime Time taken Start Time End Time Timetaken
12345 Raj
34567 Ajay
34567 Vijay
98765 Lal
67845 Mani
34213 Andrew
67809 Vinay
44356 Suraj
66654 Swetha
96975 Suji
