There might be 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 1440 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.
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.
Using the 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.
Let’s take an example to understand.
You have time at 12:01 AM in cell A1, and by using the time function we have specified 15 minutes to add, and in the result, we have 12:16 AM.
Get the Excel File
- Back to the List of Excel Formulas