Hi there,

So I have a start time, end time, and total duration time for a whole set of processes that ranges anywhere from 5 minutes to 100 hours. I need to breakdown the processes by what part of the day they occur, 12am to 6am, 6am to 12pm, etc...

Right now I'm just using nested if functions, but I am stuck when it comes to durations greater 24 hours.

Any ideas are welcome!