@Tony: sorry you didn't get a more timely reply, most people were out at OSIsoft vCampus Live! 2011 last week... I'll nudge the PI WebParts folks to see if they have anything to add ;)
There's no easy way to do what you're describing. As you note, the PI TimeRange web part cannot consume web part connections. However, the PI TimeRange web part can consume values from the querystring in the URL. With some work, you could take advantage of this by building your own batch search functionality using the Microsoft Form web part and the PI Table web part and PI OLEDB. The results of your search that you display in the PI Table could be formatted to be hyperlinks (you can't do this with PI BatchTable), and the hyperlinks could include a querystring that would pass the start and end times to the PI TimeRange web part.