How to Add Minutes to Time in Excel (Formula)

puneet-gogia-excel-champs

- Written by Puneet

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.

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 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.

time-function-to-add-time

Let’s take an example to understand.

time-function-example

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

Last Updated: December 01, 2023

1 thought on “How to Add Minutes to Time in Excel (Formula)”

  1. I’m working on an Excel spreadsheet that calculates what times prayer services are at my synagogue based upon sunset. The information in this short article made it really helpful for me to just change the time of sunset each week and automatically generate the prayer times.
    Much thanks!
    David.

    Reply

Leave a Comment