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