separates a cell that has two hours

[sprit36]

I need a macro that separates a cell that has two hours, leaving a frame on the first cell, insert a new column and put on the other timeline. Attach example. Thanks



Sorry I was wrong, you can move this topic to the VBA section

[charlesdh]

Hi,

Your sample file leaves a question.
In your example you have "Emp 3 and 4" with two time values in column "C".
Where does the second time value come from for the other Emps that goes in column "B"?