A
anthony alvarez
I am doing a vlookup with regard to time keeping
A B C D
ID Date Time Status
0001 01/01/2010 7:25AM IN
0002 01/01/2010 8:12AM IN
0001 01/01/2010 5:15PM OUT
0002 01/01/2010 6:45PM OUT
I want to have an out put like
Date Time IN Time OUT
01/01/2010 7:25AM 5:15PM
Can anybody help me please.. Best regards,Anthony
Submitted via EggHeadCafe - Software Developer Portal of Choice
XCeed Streaming Compression Library
http://www.eggheadcafe.com/tutorial...f-769ec7085cf2/xceed-streaming-compressi.aspx
A B C D
ID Date Time Status
0001 01/01/2010 7:25AM IN
0002 01/01/2010 8:12AM IN
0001 01/01/2010 5:15PM OUT
0002 01/01/2010 6:45PM OUT
I want to have an out put like
Date Time IN Time OUT
01/01/2010 7:25AM 5:15PM
Can anybody help me please.. Best regards,Anthony
Submitted via EggHeadCafe - Software Developer Portal of Choice
XCeed Streaming Compression Library
http://www.eggheadcafe.com/tutorial...f-769ec7085cf2/xceed-streaming-compressi.aspx