CODEWITHSUNDEEP
excelexcel-formulavba
afora377
afora377

Reputation: 374

Summing-if minutes shown as strings

I have a range of times in minutes displayed as strings "30", "33" etc, which I will need to sum to display as the total number of minutes. Plus a value will need to be summed only if a condition is true - hence I will need to use SUMIF if I were in an Excel worksheet proper.

Is there a quick build-in function for summing stringed minutes (ideally a sumif variant) without using extensive VBA manipulations?

Note: I cannot append another column and convert those values to Time - it will have to be done in a single 'summing' cell.

Many thanks!

Upvotes: 1

Views: 36

Answers (1)

J.Doe
J.Doe

Reputation: 596

If your minutes are just stored as text, you can use a SUMPRODUCT() :

enter image description here

=SUMPRODUCT((Ciriteria_range="Criteria")*Minutes_range*1)

Upvotes: 2

Related Questions