I`m trying to calculate the duration of a column (inputTime) but not sure how could I limit it to calculate all entries that are less than 15min apart.
example: In the below column, there has been a gap of more than 15min between entries, what I would like to achieve is that when calculating the whole duration, the expression can identify the gap and calculate only entries with less then 15min.
Hi Joseph, thanks for your reply. Took me long o get back to you.
I could have done a better job at explaining it, trying again.
I have the column DateTime (as in image) in a sheet and my aim is it know how many continuous hours (less 15min apart from last row) there are in a period of time.
This is achievable by creating another table, where each row would have a start time and end time. This table would be filled by a set of actions that check each row of your Times table against the row before and the row after. If gap with previous row > 15 min, this is my Start Time. If gap with next row > 15 min, then this is my Finish Time.
What you’re trying to do could easily cause performance problems. Rather than trying to find start and end times from a list of date-times, I would encourage you to make the determination as the date-times are collected.
