In B1 through BD1 I have employee names and in rows 5 through 23 I have clock in/clock out times. An Employee may appear several times in row 1. I have a weekly sheet that will have all the clock in/clock outs for an employee for the week.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
Is there a way to look up the times based upon employee name and for lack of a better work stack them together next to each other rather than add them? Right now I'm using sumif to add the times together but it's not giving me exactly what I want.
fficeffice" /><o></o><o
> </o>Is there a way to look up the times based upon employee name and for lack of a better work stack them together next to each other rather than add them? Right now I'm using sumif to add the times together but it's not giving me exactly what I want.
