Thank you everyone! The scope of the responses were a bit above my experience but I managed to use them to get a working solution. And needless to say...

Thanks for the quick reply Drew. I've updated the post. How would I go about it with multiple actions in the same day?

Luis C that was exactly what I was trying to do and exactly the issue I ran into. Below is some sample data and expected output. Hope this...