The data for this calculation can be found in the menu Selections | Reprots link
The procedure is as follows:
💡The "timeline" workbook contains a record of events that have taken place in the system during the given period. It gives you the data needed for calculations such as: how many interviews took place, how many candidates were accepted, how many notes were created, etc.
Once these positions have been filtered, only the data that relates to the candidate's emergence into the position, the shift between recruitment phases and rejection will be available. The calculation will not include the times of sending an email, adding a note, etc.
💡In order for the formulas to work correctly and the report to contain only this data, it is necessary to copy the result of the filtering into a new workbook so that there are no "gaps" in the data caused by not displaying the unfiltered values, which would cause the formula below to not work.
💡All actions with one candidate will be chronologically ordered from the origin of the answer to the last move. This way it will be possible to count how long each action took line by line.
The formula is used to calculate the value between adjacent rows (i.e. actions. For our calculation it is necessary that the actions belong to one candidate (satisfied condition), otherwise "X" will be shown (unsatisfied condition).
in the English version of MS Excel it is then: =IF(B2=B3;H3-H2;"X")
You set the formula on the second row to calculate the values for the first and second rows and then just copy to the entire range of rows in the workbook.
💡During the reporting period, there are likely to be events with candidates who have emerged in the past. It should be taken into account that the calculation may not cover all actions for all candidates (typically, for some candidates you will have, for example, only one action in the filtered period, e.g. rejection, and then it is not possible to calculate the duration of this state
💡It is therefore important to have the right range of data for the report, i.e. both the origin of the response and the shift between actions.
The figure below shows a sample result of such a calculation: