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

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. Then you will see that the minutes are successfully added. • Later, to copy the formula for the other cells, drag down the Fill Handle icon by using your mouse. Now see that the minutes are added to all the times. Related Content: How to Add Hours to Time in Excel (8 Quick Ways)

### 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)` • Or you can use this formula instead-
`=TIME(HOUR(B12),MINUTE(B12)+C12,SECOND(B12))`
• Then just hit the Enter button. The minutes are added now. • Finally, just drag down the Fill Handle icon to copy the formula. 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. 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.

## Related Articles #### Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts 