Hi Rob!


"I'm not sure what you mean by splitting up of the times."

I was thinking in terms of breaking the times at Midnight

We might have a row of times from 00:00 to 23:00

Then break into another row from 00:00 to 23:00

The second row can be conditional on overlapping midnight. That way
the formula approach would not need to be adjusted for the case of
stop time < start time.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Rob van Gelder" wrote in
message ...