Add 15 Minutes to Time in Excel: 4 Easy Methods

Method 1 – Use SUM Function to Add 15 Minutes to Time in Excel


  • Add a new column on the right side and remove all the minute values.

Add a new column to add minutes in Excel

  • Choose Range C5:C9 from the dataset.
  • Press Ctrl+1.

  • The Format Cells window appears.
  • Choose the Number tab.
  • Select a marked format from the Custom section.
  • Press OK.

Change the format of cell

  • Put 15 minutes in the following way.

Input minute value in the cell

  • Put the same value in Range C5:C9.

We are presenting values in terms of minutes and seconds.

  • Go to Cell D5.
  • Put the following formula.

Use the Excel SUM function

  • Drag the Fill Handle icon.

We get the required result.

Alternatively, we can use the following simple formula:


This will add 15 minutes easily.

Alternative Formula:


  • Put the following formula on Cell D5.

Apply custom formula with format to add minutes

  • Press the Enter button.

  • Drag the Fill Handle icon to get the result of the whole column.

We can see 15 minutes added with all the time values.

We can also use other custom formulas to add 15 minutes at a time. It is known that 1 day equals 24 hours and 1 hour equals 60 minutes. We convert days into minutes.

1 day =  24 X 60

= 1440 minutes

  • We will apply a formula using this value to add 15 minutes to time on Cell E5.

Apply division operation to add 15 minutes in Excel

  • Dag the Fill Handle icon.

We can also use the multiplication operation here.

  • Divide 1 day by 1440 and then multiply 15 by the result and add with the existing time. Put the following formula on Cell F5.

Apply multiplication operation to add 15 minutes in Excel

  • Press the Enter button and drag the Fill Handle icon.

Method 2 – Use Excel TIME Function


  • Put the formula below on Cell D5.

Formula based on the Excel TIME function to add 15 minutes

Add the existing time with the TIME function here.

  • Press Enter and pull the Fill Handle icon.

We got our desired result successfully.

Method 3 – Apply TIMEVALUE Function


  • Go to Cell D5 and put the formula based on the TIMEVALUE function.

A formula add 15 min minutes based on the Excel TIMEVALUE function

  • Drag the Fill Handle icon downwards.

Method 4 – Combine TIME, HOUR, MINUTE & SECOND Functions


  • Put the formula below on Cell D5.

Combining TIME, HOUR, MINUTE & SECOND functions to add 15 minutes in Excel

  • Press the Enter button and drag the Fill Handle icon.

Result of applying combination of multiple functions in Excel

Things to Remember

When we use the SUM and the NOW functions, we must change the format of added minutes.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Related Articles

<< Go Back to Add Time in Excel | Calculate Time | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF