Hey, Data Nuts!
I am stuck on a clean way to accomplish this task. I have tried formulas, multi-row tools, running totals, but have still not found a great way to do this. Most of the time I just step away for a bit and come back with a solution, but I'm hoping someone has a clean way to accomplish this.
Attached is a sample with my "current input" and "expected output." I have a workflow that references date, person, and worked time (in seconds - for use later in the workflow). Anything over 144,000 seconds is considered OT, and should move from the "regular" column to the OT column. While sometimes it will zero out the adjacent cell, other times there will be time "leftover." Essentially, each person that exceeds 144,000 in the "regular" column" should have the first 144,000 remain in that column with the excess in the OT column on its respective day. Hopefully, I've explained that well enough. And, as always, all input is greatly appreciated!
