Hi
We want to be able to match number plates using excel and creating an
output file that shows the time difference between the two number
plates. The file we get in is like this

Site Vehicle Type Reg Plate Time (Hour) Time (Min)
001 1 T890RFW 07 00
001 1 FL51FYZ 07 00
001 1 KC04PZG 07 00
001 1 P610APB 07 00
001 1 P676JKP 07 00
001 1 FG51OZB 07 00
001 1 P849GAL 07 00
001 1 R787KHP 07 00
001 1 FH52SUD 07 00
001 1 X591BAU 07 00
001 1 P258UVK 07 00
001 1 BS2200 07 01
001 1 R142GWO 07 01
002 1 FH52SUD 07 20
002 1 FG51OZB 07 29

and it needs to come out like this

Entry Place Exit Place Time Number Plate


Any help with this would be greatly appreciated. If more
clarrification is needed pls msg and i will try my best.

Skyhigh


--
Skyhigh
------------------------------------------------------------------------
Skyhigh's Profile: http://www.excelforum.com/member.php...o&userid=24907
View this thread: http://www.excelforum.com/showthread...hreadid=384449