Hello FBDibbins:

I think there is some misunderstanding.
Please open the earlier attached excel sheet.
Sheet2 shows employees ClockIn-Clockout data in the format as shown in Sheet2.
I want to translate this data for all employees so that i can see the whole month of data.
The grid for this is in Sheet3.
Since there will be one cell per employee per day in Sheet3, i wanted to have clockin-clockout data merged in one cell.
The purpose of this is to visually see who worked on which day.
Example : If for any given employee ClockIn=1002 & Clock Out=1620 then this needs to be merged as "1002-1620" (without ")in put the appropriate cell for the employee.
I will be ok with VB macro or Excel formula/function to perform this task.

I hope i have clarify my problem.

Please let me know if any questions.

Thanks

Riz