Bob,
I should have caught that missing underscore from the previous code
The code is showing some promising results, except now the last log i
time is being removed. I am going to look into what you have done her
and see if I can figure it out. Arrays are a little beyond my means bu
I am eager to learn. If you look at the current results below and yo
see a quick modification to the code that would resolve the last tim
being removed, I would greatly appreciate your input.....again....
really appreciate your time and knowledge. Below is how the data i
coming out now

Raw Date

Logout Date Login Time Logout Time
05/18/04 8:15AM 9:46AM
05/18/04 10:00AM 12:05PM
05/18/04 12:50PM 2:30PM
05/18/04 2:45PM 4:46PM
05/19/04 8:16AM 10:02AM
05/19/04 10:18AM 12:00PM
05/19/04 12:45PM 2:30PM
05/19/04 2:46PM 4:49PM
05/20/04 8:15AM 9:45AM
05/20/04 10:01AM 12:00PM
05/20/04 12:45PM 2:37PM
05/20/04 2:51PM 4:45PM

After your script is applied= As you can see the last time is missing

05/18/04 8:15AM 10:00AM 12:50PM 2:45PM
05/19/04 8:16AM 10:18AM 12:45PM 2:46PM
05/20/04 8:15AM 10:01AM 12:45PM 2:51P

--
Message posted from http://www.ExcelForum.com