How do you Increment Time by varrying times???
 

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

How do you Increment Time by varrying times???
 

To increment by different intervals, you will need to enter a formula for each,
because Excel will not be able to guess the proper interval.

You can build the increment into the formula, as in:

=a1+time(0,15,0)
=a2+time(0,17,0)
etc.

or, enter the interval in a separate column (say B), then add it to that row's
time, as in:

=a1+b2

which you can then copy down.

--
Regards,
Fred


"Crackles McFarly" wrote in message
...
I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

How do you Increment Time by varrying times???
 

Check your other posts, too.

Crackles McFarly wrote:

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

--

Dave Peterson

How do you Increment Time by varrying times???
 

On Sun, 19 Aug 2007 13:21:24 -0600, "Fred Smith"
sayd the following:

To increment by different intervals, you will need to enter a formula for each,
because Excel will not be able to guess the proper interval.

You can build the increment into the formula, as in:

=a1+time(0,15,0)
=a2+time(0,17,0)
etc.

Wow weeee, thanks sir

How do you Increment Time by varrying times???
 

Dave, which EXCEL newsgroups is most useful, most answers?

I'll try to limit myself to it..

thanks..


On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson
sayd the following:

Check your other posts, too.

Crackles McFarly wrote:

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

How do you Increment Time by varrying times???
 

See reply in other news groups you posted this to.


Gord Dibben MS Excel MVP

On Sun, 19 Aug 2007 17:48:11 -0400, Crackles McFarly
wrote:

Dave, which EXCEL newsgroups is most useful, most answers?

I'll try to limit myself to it..

thanks..


On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson
sayd the following:

Check your other posts, too.

Crackles McFarly wrote:

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

How do you Increment Time by varrying times???
 

Gord responded to your other post, but the question should be "which excel
newsgroups are most appropriate".

If you have programming questions, then .programming
if you have worksheet functions, then .worksheet.functions
if you have charting questions, then .charting
if you have setup questions, then .setup
if you're a newuser, then .newusers
..misc for miscellaneous stuff.

and there are lots of .excel newsgroups, too:
..links
..templates
..printing
..mac.office.excel

and more

But those top 5 of 6 get read by most regulars (I bet). .Charting may not be
read by all, but it's read by the really smart charting people.

Crackles McFarly wrote:

Dave, which EXCEL newsgroups is most useful, most answers?

I'll try to limit myself to it..

thanks..

On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson
sayd the following:

Check your other posts, too.

Crackles McFarly wrote:

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,

--

Dave Peterson

How do you Increment Time by varrying times???
 

Mo' better response than "any Excel news group"


Gord

On Sun, 19 Aug 2007 18:52:38 -0500, Dave Peterson
wrote:

Gord responded to your other post, but the question should be "which excel
newsgroups are most appropriate".

If you have programming questions, then .programming
if you have worksheet functions, then .worksheet.functions
if you have charting questions, then .charting
if you have setup questions, then .setup
if you're a newuser, then .newusers
.misc for miscellaneous stuff.

and there are lots of .excel newsgroups, too:
.links
.templates
.printing
.mac.office.excel

and more

But those top 5 of 6 get read by most regulars (I bet). .Charting may not be
read by all, but it's read by the really smart charting people.

Crackles McFarly wrote:

Dave, which EXCEL newsgroups is most useful, most answers?

I'll try to limit myself to it..

thanks..

On Sun, 19 Aug 2007 14:32:20 -0500, Dave Peterson
sayd the following:

Check your other posts, too.

Crackles McFarly wrote:

I'm using, and love it, Excel 97. I want to know how to increment
TIME.

Say I have a few rows, each start at 10:00 AM and I want each to
increment at different intervals. Let's say row 1 is 15 min, row 2 is
17 minutes, row 3 is 60 minutes, row 4 is 75 minutes, etc..etc..

I cannot find documentation about this within Excel NOR on Microsoft's
web site.

Does anyone of you know how to do this? I'd sure appreciate the help.
thanks,