Time increments

[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

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ntisch]

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

[JE McGimpsey]

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 <[email protected]>,
Ntisch <[email protected]> wrote:

> I am getting an error when I enter your formula as;
>
> = A1+Time(),15,0)
>
> Is there something I have left out?

[Ntisch]

This works a treat - many thanks