Finding Weekly Totals

Why are you not counting all the minutes for every day? It looks like you are counting only the minutes in the last row for each day.

This could be done with macros, might also be possible with formulas. Do you have a preference?

This would also be a lot easier if instead of the names of the days you had the actual dates.

Thanks 6String

Yes I do actually have the dates of each event. Also I can keep a cumulative or running total of minutes for the events. The part that is puzzling to me is creating a "flag" to start and stop the count. To make this much easier, I have modified the sample file and am uploading it again with additional columns.

Note that each row or event is entered one at a time via a macro. You will note that the second Weekly Total shows up on the last row for a Monday. This is due to the fact that NO events occurred or were entered on Tue of that week. This can only be known when the FOLLOWING event is entered and the Day of that event is beyond Tuesday. Then the weekly total needs to be inserted on the prior row (Event 18) which is the last event of the week.
I would like to include this as part of the code which "Posts" the data to the table - one record at a time. Hence as each record is entered, the entry date must be checked to see if it is at least a "Wednesday". But if there is no event on Wed, then if would be Thursday or later. Each time there is a Weekly Time posted the "counter" needs to reset back to zero.

Thanks for your help.