How do you Increment Time by varrying times???

  • Thread starter Thread starter Crackles McFarly
  • Start date Start date
C

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,
 
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.
 
Check your other posts, too.

Crackles said:
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,
Click to expand...
 
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.
Click to expand...

Wow weeee, thanks sir
 
Dave, which EXCEL newsgroups is most useful, most answers?

I'll try to limit myself to it..

thanks..
 
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.
 
Back
Top