For example, let's say you enter a part name into an order form.
For an average business day you should expect about 24 hours before your first response.
The other columns contain array formulas to calculate various metrics e.g. Note: in general, and especially if your forms are complex, you should consider keeping the response data in its own sheet, and doing any data analysis in a separate sheet.
Array Cumulative SUM: To get the total of all values in column B, enter this formula in the top row (e.g.
You can Auto Fill and choose to ignore preferences, but it still is really good information to know when you are trying to find a last minute replacement.
It allows you to know who might be the best choice to assign.
There really is no down-side to letting employees enter their prefer and dislike times.