Creating a Column of Times Incrementing by 5 Minutes Per Cell (SS)

Here are step by step instructions for a method to create a spreadsheet where the first column will contain times that will appear in 5 minute increments beginning at 8:00 AM.

This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.

To create the column of times, follow the steps below in a Spread Sheet document:

1) Click on your column heading to select the whole column.

2) From the Format menu select Number and click on the time format that you want to display.

3) In the first cell of the column type in "=TIME(8,0,0)" (This will set the time to 8:00 AM)

4) In the next cell down* type "=A1+TEXTTOTIME(0.5)" *Note that A1 is the cell that was used as the first cell in the time column.

5) Now click into the second cell (A2) and drag your mouse down as far as you need to accommodate all of your times.

6) From the Calculate menu select Fill Down.

Now you have times beginning at 8:00 AM and incrementing five minutes in each cell.
Published Date: Feb 18, 2012