Hi, I need help calculating the values as shown here from below table based on time where the calculated value (160 in below example) will be populated in a new column. Can someone please advise how it can be done. Thanks in advance. Week 1 Day 1, time1 + Day 1, time 2 (80+80 = 160) Week 13 Day 9, time 1 + Day 9, time 2 (80+80 = 160) Week 13 Day 10, time 1 + Day 10, time 2 (80+80 = 160) Week 13 Day 11, time 1 + Day 11, time 2 (80+80 = 160) Week 13 Day 12, time 1 + Day 12, time 2 (80+80 = 160) Week 17 Day 13, time 1 + Day 13, time 2 (80+80 = 160) Week 17 Day 14, time 1 + Day 14, time 2 (80+80 = 160) Week 17 Day 15, time 1 + Day 15, time 2 (80+80 = 160) this is how data is in the dataset week Day/time Score Week 1 Day 1, time 1 80 Week1 Day1, time2 80 Week 13 Day 12, time 1 80 Week 13 Day 12, time 2 80 Week 13 Day 9, time 1 80 Week 13 Day 11, time 1 80 Week 13 Day 11, time 2 80 Week 13 Day 10, time 1 80 Week 13 Day 10, time 2 80 Week 17 Day 14, time 1 80 Week 17 Day 14, time 2 80 Week 17 Day 13, time 1 80 Week 17 Day 13, time 2 80 Week 17 Day 15, time 1 80
... View more