How to Add Minutes to Time in Excel (3 Quick Methods)

We often use time in our worksheets for business purposes, educational purposes, and many others. In some cases, we need to add or subtract time in the worksheet. Excel offers some quick ways to do it smartly. This article will provide you with 3 quick methods to add minutes to time in Excel with sharp steps and vivid illustrations.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


3 Methods to Add Minutes to Time in Excel

Let’s get introduced to our dataset first. I have used some different times in my sheet and I’ll add 15 minutes to all the times.


Method 1: Use Manual Formula to Add Minutes to Time in Excel

In our very first method, I’ll show how to add minutes to time using manual formula. For that, we need to know some information about time in Excel. Excel stores time value in a decimal number. Time is a fractional value of 24hrs in Excel.

So,

  • 1 day = 24hours
  • 1 hour = 1/24
  • 1 minute = 1/(24*60) = 1440
  • 1 Second = 1/(24*60*60) = 1/86400

So if we want to add minutes manually then we’ll have to multiply that minutes by 1/1440 before adding.

Now I’ll add 15 minutes to all the times in the sheet.

Steps:

  • Activate Cell D5 by pressing it.
  • Type the following formula in it-
=B5+(15/1440)
  • Press the Enter button to get the result.

Manual Formula to Add Minutes to Time in Excel

Then you will see that the minutes are successfully added.

Manual Formula to Add Minutes to Time in Excel

  • Later, to copy the formula for the other cells, drag down the Fill Handle icon by using your mouse.

Manual Formula to Add Minutes to Time in Excel

Now see that the minutes are added to all the times.


Method 2: Insert Excel TIME Function to Add Minutes to Time

Using the TIME function to add minutes to time in Excel is one of the easiest methods. The TIME function is used to create a time with individual hour, minute, and second components.

Syntax of TIME Function:

=TIME(hour, minute, second)

Arguments:

hour – (Required) The hour for the time you want to create.

minute – (Required) The minute for the time you want to create.

second – (Required) The second for the time you want to create.

Let’s use it to do the task-

Steps:

  • Write the following formula in Cell D5
=B5+TIME(0,C5,0)

TIME Function to Add Minutes to Time

  • Or you can use this formula instead-
=TIME(HOUR(B12),MINUTE(B12)+C12,SECOND(B12))
  • Then just hit the Enter button.

TIME Function to Add Minutes to Time

The minutes are added now.

TIME Function to Add Minutes to Time

  • Finally, just drag down the Fill Handle icon to copy the formula.

TIME Function to Add Minutes to Time

Then you will get all the outputs like the image below.


Method 3: Apply Excel NOW Function to Sum up Minutes to Current Time

We can add minutes to the current time by using the NOW function. The NOW function is used to return the current date and time and it updates continuously when a worksheet is changed or opened.

Syntax of NOW Function:

=NOW()

Arguments:

The NOW function has no arguments.

Now I’ll add 15 minutes again to the current time.

Steps:

  • In Cell C5 type the following formula-
=NOW()+15/1440
  • Later, just click the Enter button for the output.

NOW Function to Sum up Minutes to Current Time

Here’s the new time after adding the minutes to my current time.


Conclusion

I hope all of the methods described above will be good enough to add minutes to time in Excel. Feel free to ask any question in the comment section and please give me feedback.

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Excel is an amazing softwear. Here i will post excel related useful articles. I am a graduate from Bangladesh University of Engineering and Technology. I love to learn new things and work with it. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo