VB Code to calculate weekly hours for employees

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

rizmomin, hello.

Why do Employee#4 at 8-04-2014 have two In/Out rows?