I have a rather complex formula that I need to build. Basically I get a list of data every month, and there is a metric for the first operator of the day. The first column comes in the date and time format. I basically need to write a formula that says if this is the first occurrence of this day then subtract the scheduled time with actual start time. Once I do that I will need to basically say if this is greater than 15 minutes we ding him. So then I'll just have a numerator (number of dings ) and a denominator (total number this operator was first) throughout that month. Any help would be awesome!
I can't comment, hence the answer.
If you could post a sample data here it'd be more helpful.
However, from what I can understand you could use COUNTIF(current row - 1, current row). And then nest it within IF statement -- if(countif = 1, do some calculations, something else).