Thanks for the reply.

Pulling the time into a separate column and filtering that works manually but not if I do a numbers between.

The two macros from the cross post seem to get the job done http://www.ozgrid.com/forum/showthread.php?t=197170.