You need to denote midnight shift ends as 24:00 rather than 00:00. (And 1am / 2am etc finishes as 25:00 / 26:00 and so on).