Explanation
Excel times are numbersand can be summed like other numeric values.
These values are hardcoded in the range F5:F7.
When the formula is copied down the column, F5 changes at each new row.
The two named ranges,timesandstates,are fixed and do not change.
In each row, SUMIFS correctly shows the total hours logged for a given state.
Note when time exceeds 24 hours, you will need to use a custom time format as explained below.
Without names ranges
Thenamed rangesin this formula are used for convenience only.
Named ranges are automaticallyabsolute, so there is no need to lock references manually.
However, the named ranges are entirely optional.
