Share via

How can I drag the time in a column to add 15 min to each row? Can I use a foormula for the time?

Anonymous
2016-04-26T09:36:22+00:00

I want to make an Excel spreadsheet for a schedule.  In Column 1, I want to put the time in 15 min. increments for 24 hours.

     So...

Cell A2 would be 12:00 AM

Cell A3 would be 12:15 AM

Cell A4 would be 12:30 AM

etc.  - adding 15 min to the time for each row until a full 24 hours is done.

If I just try to drag the time, I get hourly increments.

I've been searching the Excel help documents and have found how to add and subtract time and have the results in another cell.

I cannot however find out how to make a formula to add 15 min to the time for each row so that I can just drag down the column for the 24 hours to get it done quickly. 

Can someone please help me with this?  Thank You!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2016-04-27T23:45:58+00:00

    Hi,

    Try this

    1. Type 12:00 in cell A2
    2. In cell A3, enter =A2+TIME(0,15,0)
    3. Drag cell A3 down

    Hope this helps.

    60+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2016-04-27T15:15:24+00:00

    You must select both A1 and A2 together before dragging down.

    Gord

    20+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-04-27T15:08:28+00:00

    Cell A2 would be 12:00 AM

    Cell A3 =A2+"00:15"

    then drag down

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-04-27T14:37:31+00:00

    Thank You, I tried both of your solutions, however it does not work.  It comes out:

    12:00

    12:15

    13:15

    14:15

    15:15

    16:15

    etc.

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-04-26T10:31:43+00:00

    If you enter 12:00 in A1 (new workbook) and 12:15 in A2 and drag this down you should get your answer.

    If not then set the number format of the first 2 cells to custom h:mm and then drag it down you should get the same result.

    0 comments