Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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.


Download Practice Workbook

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


3 Suitable Ways to Add 30 Minutes to Time in Excel

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.

add 30 minutes to time in excel


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.

Use TIME Function to Add 30 Minutes to Time

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

Use TIME Function to Add 30 Minutes to Time

Read More: Add 15 Minutes to Time in Excel (4 Easy Methods)


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

Insert Mathematical Formula to Add 30 Minutes to Time

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

Insert Mathematical Formula to Add 30 Minutes to Time

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


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.

Apply NOW Function with Custom Format to Add 30 Minutes to Time

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

Apply NOW Function with Custom Format to Add 30 Minutes to Time

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

Apply NOW Function with Custom Format to Add 30 Minutes to Time

Read More: Adding Hours and Minutes in Excel (4 Suitable Methods)


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

Md. Abdur Rahim Rasel

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

Leave a reply

ExcelDemy
Logo