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.

Read More: Add 15 Minutes to Time in Excel

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.

Read More: How to Add Hours and Minutes in Excel

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.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Add 30 Minutes to Time.xlsx

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.

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

Get FREE Advanced Excel Exercises with Solutions!