Excel Formulas to Calculate the Sum of Time Over 30 Minutes!!

When subtracting or adding time in Excel, you may sometimes want to display the results as the total number of hours, minutes, or seconds. The task is a lot easier than it may sound, and you will know the solution in a moment. From this tutorial, we will discuss how to calculate the sum of time over 30 minutes in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

Use the below formula to sum the time over 30 minutes in Excel.

=SUMPRODUCT((range-TIME(0,30,0))*(range>TIME(0,30,0)))

Syntax Explanations:

*SUMPRODUCT * – The SUMPRODUCT Function in Excel multiplies the corresponding arrays or ranges and returns the sum of the products.

TIME – This function helps to create time on your worksheet. Read more on the Time Function.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Multiplication (*) – In this symbol will multiply any two values or numbers.

Range – It specifies the input times from your worksheet.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, we will enter the input values in Column B and Column C.

Here, we have to calculate the total times which are less than 30 minutes.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Verdict:

Hope you like this article on how to find the sum of time over 30 minutes in Excel. Hope you like it. If you are stuck or need some help, comment below, and I will try to help as much as possible.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Excel Formulas to Calculate the Sum by Fiscal Year ~ Quick Method!!

How to Search for a Value in All Tabs in Excel Office 365?

Excel Formulas to Parse Time String to Time ~ A Complete Tutorial!!

How to Count missing values in a list in Excel Office 365?