Ok so I need help calculating time interval data that is sequential in nature. To preface, this time data has already been filtered on a variable that isn't shown and I don't believe is necessary for this exercise. You will notice from my color shading where the time intervals break and pick back up.
I have several thousand rows of time stamped data, and I need to calculate the time interval (in minutes) over each and every interval of time. I've shown an example below to illustrate.
Column 1 = Date
Column 2 = Time (color shaded)
Column 3 = Time Interval in Minutes (done by hand for show)
The time stamps are consistently on a 15 min interval.
Is there a formula or function that I can use in excel to recognize the sequence, count the "chunks" of time in column 2, and put it in column 3?
Any help would be appreciated. If you need any further information, please feel free to ask.
Thank you in advance.
I have several thousand rows of time stamped data, and I need to calculate the time interval (in minutes) over each and every interval of time. I've shown an example below to illustrate.
Column 1 = Date
Column 2 = Time (color shaded)
Column 3 = Time Interval in Minutes (done by hand for show)
The time stamps are consistently on a 15 min interval.
Is there a formula or function that I can use in excel to recognize the sequence, count the "chunks" of time in column 2, and put it in column 3?
Any help would be appreciated. If you need any further information, please feel free to ask.
Thank you in advance.