Hi everyone,
Please help me with the right formula.
I have 21 resolved cases for the month of January and I would like to know how to get the data for the cases resolved in less than a week and more than a week.
Sad to say I cannot attached the file because my karma point is just 1
Please show example data and the desired result. Also, what formulas have you tried so far? Take a look at Guidelines for asking - #4 by jimk.
To provide files, you might use free services like filebin.ca
One of many possible ways is to use the SUMPRODUCT function
Like as in this demo - counting-time-duration.ods