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:

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

2014-10-09 Thread Paul Schreiner
I'm sure there are LOTS of approaches to this, but using simple Excel functions, I went with this approach: Assuming: From: time is in row 1 To: time is in row 2 Data begins in row 3 I added a blank column at column B to show that that at the start of the day, no task is being worked on. I