Hi Everyone,
Much help required I am looking for the best formula options to count incidents within a 24 hour period.
I have a list of job times, in a very busy period if incidents reach a certain level it triggers an action. I need a way of working out when the trigger was reached. I have done this with a Match formula but have tried others. I am looking for advise as to the best/most accurate formula.
Please see attached spreadsheet.
Much help required I am looking for the best formula options to count incidents within a 24 hour period.
I have a list of job times, in a very busy period if incidents reach a certain level it triggers an action. I need a way of working out when the trigger was reached. I have done this with a Match formula but have tried others. I am looking for advise as to the best/most accurate formula.
Please see attached spreadsheet.