Using "Time" in Calculations

[mmillerct]

I am trying to run a series of times in a column.

In the first row, I have entered a time, using an appropriate time format, to yield "8:00:00 AM".

I want to increment each row in that column by 1 hour, so the next row displays 9:00:00 AM and the next 10:00:00 AM and so on.

I haven't gotten it to work right yet.

Help!



mmillerct

[Andrew-R]

If your first time is in, say A1, then in A2 use:

=A1+(1/24)

And make sure that A2 is formatted to one of "Time" formats.

[CheshireCat]

In the second row/cell, enter the time to yield 9:00 AM.

Select both cells.

click and drag the autofill handle (lower right corner of selected range) down to the desired amount.