How do you Increment Time by varrying times???

[Crackles McFarly]

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,

 

[Fred Smith]

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.

 

[Dave Peterson]

Check your other posts, too.

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,

 

[Crackles McFarly]

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

 

[Crackles McFarly]

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

I'll try to limit myself to it..

thanks..

 

[Dave Peterson]

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.

 

[Gord Dibben]

Mo' better response than "any Excel news group"


Gord