>I do recall running into an odd situation where it was necessary to have a value representing 24:00 as well as the 00:00.

Not odd at all. On railway timetables, the midnight is 24:00 if it's an arrival time (so this leg of the train's trip ends within the same day) and 0:00 if it's a departure time (so the whole trip is again in the same day).