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" <Ntisch.1w3iqe_1127955950.0827@excelforum-nospam.com> wrote in
message news:Ntisch.1w3iqe_1127955950.0827@excelforum-nospam.com...
>
> 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
>