ahhh DateDiff(), I'm pretty sure that was not part of my vocabulary at the time I wrote this. I think all the mumbo-jumbo I've provided was to get a more accurate offset and not just in hours, I'd like the minutes to. I'll give your suggest a run at work in a few and let you know how the results go. I was also thinking of just replacing this with a function - and again this was a while ago so I'm not even 100% sure why I chose to use a view in the first place.

thanks tg!