Create a Procedure

(sorry, I'm not sure whether to post it in function section or here)

I have the MAIN worksheet which summarizes data from different sheets.

HTML Code: 

**END TIME is based on the particular time the last case for that "batch" is done. (ex. Employee 1's 7th case was done at 5:06)
**START TIME is provided, BUT, if the END TIME from previous "allocations" is greater, the END TIME will be used as the START TIME (ex. Employee 3's START TIME)

I was able to do it with a simple IF-THEN command, yet, it can only be done only up to 4 alloc (or allocations), beyond that, I already get an error (something about too many arguments, etc). I'm not familiar that with procedures (or functions), so, I was hoping someone will be able to help me translate it into procedures (or functions).

TIA.