Hello:
Please refer to attached file.
I have employee Clockin_Out info as shown in the excel file for shown date in cell A1,E1,I1....Y1
Below is what i would like to accomplish.
Need a VB Code to add Employee Names starting in cell AC2,AC3,AC4, etc., example Misty,Barbara etc.
Then put Date in Cell AD1,AE1....AJ1....this will be date as in cell A1,E1,I1,....Y1
Now i need to calculate the hours for each employee as in column AC for each day and then add all hours for ech enployee in Column AK.
Hint : Need to pick up Clock In/Clock Out info for each employee and calcualte the hours and put in column AD to AJ accordingly.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks