really sitting before this screen for long time
what could you mean
for the life of me, why can a question look so complicated while it should be simple
let's take it another way:
you are writing down events in a sheet, right ?
I can see you are trying to calculate kinda "surfaces" (integrates)
when the times change such that Event Three occurs after the hour point
you have problems when - lost here - there aren't "enough" events within an hour, or ???
I would need the hour point to be between Event 2 and Event 3.
all this looks to me as if you absolutely want to have 3 (or 4?) events within an hour, but there aren't so much events, or ???
this is an Excel-forum
we try to find solutions to problems
when the problem still is to figure out what the problem is, then we've really got a problem !
I would like to encourage you to rethink your question, staying practical (no theorethical)
what purpose will your sheet have ?
what practical use do you want to get from it ?
still willing to help, but how ?