Recent content by michwh1

Thanks You're right. Works fine. I appreciate the help.

Still an issue I am still having a problem with this one. The key issue is that the times are all in the same field and I am unsure how to distinguish the first in/out times from the second.

Thanks Thanks. That helps

I have a file that collects the time data of the shop employees. It records time in (start of day), time out (lunch start), time in (lunch end) and time out (end of day). Sample of the table: In/Out Employee ID Date Time 0 316 11/2/2006 7:00:34 AM 0 1244 11/2/2006 7:05:00 AM 1 316...