Excel highlights the cells above B15, including the blank cell. 3. In the Defined Names group under the Formulas tab, click the Use in Formulas button and select the range name Quantity from the list.

The current set of input cells begins the series at 8:00 a.m. and increments each value by two hours and 30 minutes. Don’t forget to change the format if you want the time values to display seconds.