Add Minutes to Time

HomeExcel FormulasAdd Minutes to Time

There might a situation when you need to add specific minutes to a time that you already have in a cell in Excel.

In Excel, time is stored as a fraction of a numeric value, so, a complete day of 24 hours is equal to 1. And in this tutorial, we will learn how we can do this using a formula.

Adding Minutes to Time

Now think this way: there is (24*60) a total of 144 minutes in a day. So, if you want to add one minute in a time value that would be (1/1440). In the following example, you have the time 12:01 AM in cell A1.

adding-minutes-to-time

=A1+(10/1440)

In cell B1, we added (1/1440) minutes to the value from cell A1, and we got 12:02 AM.

Now, let’s say you want to add a new more than one minute (ten minutes), in that case, you need to add (10/1440) in the time value.

See the following example to understand.

add-more-than-one-minute

Using TIME Function to Add Time

You can also use the TIME function to add minutes to a time. Using this method has a benefit over the previous method: you don’t need to calculate the minutes.

The time function allows you to add minutes as a number in the argument, so if you want to add 15 minutes or 30 minutes, you can simply enter it into the function.

There are three arguments in the TIME function, and you need to specify the minutes’ values in the second argument.

time-function-to-add-time

Let’s take an example to understand.

time-function-example

You have time 12:01 AM in cell A1, and by using the time function we have specifies 15 minutes to add, and in the result, we have got 12:16 AM.

🡠 Back to Excel Formulas List