I have a column that has 34 records of Week Day, Month/Day, and Times. I am looking for two formulas or a script that I can use in a table that will give me the count of weekdays and the time duration per day. Eventually, I would like to just copy and past new dates into column A and have the table automatically calculate. Here is my google sheet example. Anything to help automate the process will be helpful.
Time Duration
Time Duration