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

Get FREE Advanced Excel Exercises with Solutions!

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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF