Time increments

  • Thread starter Thread starter Ntisch
  • Start date Start date
N

Ntisch

Hi - I use Excel Office 2004 for Mac.

I am trying to create a timeline of hours and minutes that I can adjust
down a spreadsheet.

For example the first value would be 2pm (in cell A1) and then I want
to increase by 15 minute increments down the sheet by programming cell
A2 as (A1+15), cell A3 as (A2+15) etc.

Is this possible?

Thanks, Nik
 
In A1 enter 14:00
In A2 = A1+Time(),15,0)

Then just drag and copy A2 down.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi Bob - thanks for the response.

I am getting an error when I enter your formula as;

= A1+Time(),15,0)

Is there something I have left out?

regard
 
There was a typo. Try

=A1 + TIME(0, 15, 0)

which is equivalent to

=A1 + 1/(24*4)

or

=A1 + 1/96

with the cell(s) formatted as times.
 
Back
Top