[QUOTE=gluonman;112658]Alright, PecoFlyer's solution came the closest to what I needed. I only needed to add in the additional logic I talked about in my original post in order to adapt it, and it's now working perfectly. That and it's a significantly more efficient solution than that beast I wrote. Thank you so much.

xor and trevorc's solutions also work, in case you need to report totals as a time value, but their solutions do not provide decimal values for totals, which I had specified in my post. But still, thanks for contributing and being helpful.


That's fine.
It may not at all be a problem, but be aware that your preferred solution doesn't allow for times to cross midnight (for example 2200, 2300 2330 and 130 in A1, B1, C1 and D1 respectively).
(and the decimal values problem is just to multiply the value in K9 with 24 and format K9 as General).