How to Use AutoFill and Excel Formulas Increment Time Intervals

This is the 2nd part of my two-part series where I demonstrate how to take advantage of AutoFill in Excel to increment a series of Time Intervals.

I share a great shortcut that ensures that you always enter Time Values correctly in Excel - this is one of the major "frustrations" that Excel users have - they - inadvertantly - enter a time as a "text value."

The real power in Excel is to take advantage of formulas. I show you how to create formulas to increment in two-hour intervals and also in 15-minute intervals.


Danny Rocks
The Company Rocks

[christopherthibeaultt]

11 years later, and still helping people all around the world. Thank you so much!!!

[christianrivera]

you saved my life man, i was manually inputting everything, times by 1 minute intervals, copy and pasting line by line spamming CTRL+V over and over again LOL..this series will be a huge help for me, thank you so much!

[debbyclowney]

Extremely clear, well-paced, and helpful explanation of the unintuitive way Excel deals with time. Thank you, Danny!

[DannyRocksExcels]

Hi Rodney - Thanks! I am happy that I could save you and your team so much time as a result of my Excel tutorial.

Thanks for adding your feedback!

Danny Rocks
The Company Rocks

[mohamadelias]

Thank you very much, you are awesome in making things easy and easy to understand.

[nerdrd]

been searching for half a day and my crisis was solved without even watching the entire video b/c you explained how excel sees time. thank you!

[jwilliams]

I needed to add a time formula into a college assignment and your video came up on the windows help and after watching I now have the formula to increase my time in 1 minutes intervals. Thank you it was genuinely a big help.

[sajangva]

Thank you Danny, it was so helpful your presentation. Just a quick tip: on the sections of increment by hours and increment by minutes, instead of using the formula just fill up two cells with incrementing values and select two cells together and use the fill series option (drag the curser)

[rachellynn]

Bless this saved my life just now for my research

[DannyRocksExcels]

@0sarabear0
My pleasure! I am delighted that you wrote to tell me that I was able to help you with this topic.

Sincerely,

Danny Rocks
The Company Rocks

[rockywalterful]

I'm SO glad you made this video! Saved me and my team a bunch of time, thanks!

[DannyRocksExcels]

I am so pleased that I could help you with my tutorial.

Thanks for adding your comment.

Sincerely,

Danny Rocks
The Company Rocks

[rodraymundo]

thank you for saving my time.... a lot

[purcell]

Holy shit! THANKS MAN!!!!

I was about to subject myself to manually entering in time for every 15 minutes for a 24 period. You saved me potentially hours of editing just he time cells!

[Ldeevaj]

it took me hours to try and figure this out on my own and thru microsoft Excel Help. Thank you!

[CollinGreen-xz]

Thanks for making it simple to understand

[amelia]

I just customised the formula at around 5:25 and it worked! Thanks so much.

[amychou]

Thank you so much! This is incredibly helpful!

[Gorillap]

Thank you! This was really helpful for creating my revision timetable! :)

[DannyRocksExcels]

Gian -

Thank you for your feedback.

I am pleased that i could help you with my Excel Tutorial!

Danny Rocks
The Company Rocks