Edit Fill Series - How do I fill using minute increments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with time formula 12
Fill date series 2
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
Series fill only copying and fill series greyed out 1
autofill date times 4
Even date time distribution 4
consecutive date numbering by rows of 4 5
Delete Row with condition 4

Back
Top