So my basic problem is this: I have a database full of start times and end times for shifts at a computer lab. I want to calculate dead time (time with no shifts scheduled). I could easily do this ...