View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.worksheet.functions
Crackles McFarly Crackles McFarly is offline
external usenet poster
 
Posts: 49
Default 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