# How to Add 30 Minutes to Time in Excel (3 Easy Methods)

We often use time in our worksheets for business purposes, educational purposes, and many others. Sometimes, 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 three quick methods to add 30 minutes to time in Excel effectively with appropriate illustrations.

## Add 30 Minutes to Time in Excel: 3 Suitable Ways

Letâ€™s get introduced to our dataset first. I have an arbitrary time in my sheet and Iâ€™ll add 30 minutes to the times.

### 1. Use TIME Function to Add 30 Minutes to Time

Using the TIME function to add 30 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. Letâ€™s follow the instructions below to add 30 minutes to time!

Steps:

• First of all, select cell D5 for the convenience of our work.

• After selecting cell D5, type the following TIME function in the Formula Bar,
`=B5+TIME(0,C5,0)`
• Where B5 is the arbitrary time, and inside the TIME function first 0 is the hour, C5 is the minute, and second 0 is the second of the TIME function.

• Hence, press Enter on your keyboard. As a result, you will be able to get the return of the TIME function and the return is 10:00:25.

### 2. Insert Mathematical Formula to Add 30 Minutes to Time

In this method, Iâ€™ll show how to add 30 minutes to time using a mathematical 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 24 hours 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 30 minutes then weâ€™ll have to multiply that minutes by 1/1440 before adding. Letâ€™s follow the instructions below to add 30 minutes to time!

Steps:

• First of all, select cell D5 for the convenience of our work.

• After selecting cell D5, type the following Mathematical formula in the Formula Bar,
`=B5+C5/1440`
• Where B5 is the arbitrary time, and C5/1440 is the fraction value of 30 minutes.

• Hence, press Enter on your keyboard. As a result, you will be able to get the return of the Mathematical formula and the return is 10:45:25.

### 3. Apply NOW Function with Custom Format to Add 30 Minutes to Time

If we want to see what the time will be from now after adding 30 minutes. We can also have a look at the current time after adding 30 minutes by using the NOW function in Excel. This function has no arguments. And remember that, the NOW function will continuously update the time. Letâ€™s follow the instructions below to add 30 minutes to time!

Step 1:

• First of all, select cell D5 for the convenience of our work.
• After selecting cell D5, type the following NOW function in the Formula Bar,
`=NOW()`
• Hence, press Enter on your keyboard. As a result, you will be able to get the return of the NOW function and the return is 8/29/2022 12:08.

• Now, we will use the Custom format to convert this time into the only hour, minute, and second. To do that, simply press Ctrl + 1 on your keyboard.

• Hence, a Format Cells dialog box will appear in front of you. From the Format Cells dialog box, do like the below screenshot.

• As a result, you will convert the return of the NOW function into time to the only hour, minute, and second.

Step 2:

• Further, type the below formula in the Formula Bar. The formula is,
`=B5+C5/1440`
• After that, press Enter on your keyboard. As a result, you will be able to get the return and the return is 12:46:48.

## Things to Remember

âžœ While a value can not found in the referenced cell, the #N/A! error happens in Excel.

âžœ In the TIME function, the #NUM! error occurs if the given hours are less than 0.

âžœ The #VALUE! error occurs when any of the given inputs are non-numeric.

## Conclusion

I hope all of the suitable methods mentioned above to add 30 minutes to time will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.

## Related Articles

<< Go Back to Add Time in Excel | Calculate TimeÂ | Date-Time in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF