Re: $$Excel-Macros$$ Calculating Number of Context Changes in a Series

2014-10-09 Thread jlobrien222
Thank you so much, Paul! That worked perfectly! I very much appreciate your quick help! On Thursday, October 9, 2014 1:51:57 PM UTC-5, Paul Schreiner wrote: > > I'm sure there are LOTS of approaches to this, > but using simple Excel functions, I went with this approach: > > Assuming: > From:

$$Excel-Macros$$ Calculating Number of Context Changes in a Series

2014-10-09 Thread jlobrien222
Hello! I have a spreadsheet of time tracking data. Each row is a different activity and members are tracking time to that activity by entering an "x" for each 15 minute interval that they completed that activity. I would like to calculate per task, how many times they started and stopped that