We had a similar problem here. My solution was to use datediff to work out the number of minutes remaining in the shift on the first day and the number...
I'm looking for a general overview of the estate for senior management. There's no point telling them about latch waits or buffer cache hit ratios because they would neither care...