View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Edit Fill Series - How do I fill using minute increments

One way:

Enter 8:00 in A1. Enter 8:05 in A2. Select A1 & A2. Grab the fill handle
(lower right corner of the selection) and drag down as far as required.

alternatively,

Enter 8:00 in A1. Select the desired range. Choose Edit/Fill/Series...

Choose Type:Linear. Enter 0:05 in the Step field. Click OK.


In article ,
"IUnknown" wrote:

Trying to do a series using 5 minute increments (08:00, 08:05, 08:10, etc.).
Only options by date are day, wekday, month, and year.