Finding Weekly Totals

I will try to attach a simplified file to illustrate what I want.
I use macros to generate a database-like table one row at a time for each event. One portion of the table shows a column of weekdays in which an event took place, the next col shows duration for that event in minutes. I want to use vba to get a weekly total of minutes at the end of every Tuesday (except that if there are no entries on a particular Tuesday, then cumulative minutes since the last weekly total.) In other words it needs to keep a running total that will be reset back to zero every Wed morning or at the next event after Tues.


[ATTACH]195913/ATTACH]