I am currently trying to measure the Elapsed Time of a database of sets of dates with different start dates and different numbers of rows. I am trying to SUM the time intervals between each row, while also having the start of the SUM reset after each data set. My current strategy doesn't seem to be working as when I try to take the SUM of the area between two ADDRESS functions, it returns the sum between the columns, instead of substituting in the ADDRESS location. If there's a way to correct the current formula in the 'Elapsed Time' column that'd be great, or if you have a different strategy all together I am open to anything!
Thanks.
Excel Snapshot.PNG
Bookmarks