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


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=471621

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)


"Ntisch" wrote in
message ...

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


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile:
http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=471621

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?

regards


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=471621

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.

In article ,
Ntisch wrote:

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

= A1+Time(),15,0)

Is there something I have left out?

This works a treat - many thanks


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=471621