Please change the above formula to =A1+TIME(0,0,20), and then press the Ctrl + Enter keys at the same time. You can see each cell time is added with 20 minutes increments and listed in selected range immediately.įor adding time with 20 seconds increments: Here I select A2:A15.įor adding time with 20 minutes increments:Įnter formula =A1+TIME(0,20,0) into the Formula Bar, and then press the Ctrl + Enter key simultaneously. Enter the start time into a blank cell (says A1), then select the following blank cells which you need to fill with increment time. You can apply the following formulas to add time with hours/minutes/seconds increments in Excel.ġ. Supposing you are a stock investor, and you need to record the price variety of a certain stock every 20 minutes, what would you do to quickly create the time list with 20 minutes increments? This article shows you several methods to solve it in details.Īdd time with hours/minutes/seconds increments with formulaĪdd time with hours/minutes/seconds increments with Fill HandleĪdd time with hours/minutes/seconds increments with Kutools for Excel

How to add time with hours/minutes/seconds increments in Excel?