Excel SUMIF with times

Good Afternoon

I am currently using a =SUMIF formula to look through a sheet of data and calculate the total time for a specific person. For example:

Rob   00:35:00
Rob   00:25:00

However this does not apear to return the 01:00:00, I was expecting. Have I got the formate of the =SUMIF cell incorrect or do I need to use a different method to cope with calculating time?

Thank you

Who is Participating?

Improve company productivity with a Business Account.Sign Up

yuppyduConnect With a Mentor Commented:
Is this what you need?
Saqib Husain, SyedEngineerCommented:
You have not provided

The formula you used
The result of the formula
The column names for the data

which would make it easier to help you. The best thing would be to upload an excel workbook showing what you have done.
Rob HensonFinance AnalystCommented:
What seems to be the problem?

35 Minutes plus 25 minutes = 1 hour as correctly calculated by your formula.

Rob H
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

barry houdiniCommented:
SUMIF should work fine - using yuppydu's setup you can use this formula


SUMIF is normally preferable to SUMPRODUCT, it's more efficient

format result cell as a time value, for elapsed time use [h]:mm

regards, barry
Hi Barry, cannot compete with you. Still using some of the magical formulas you gave me time ago.
Rob HensonFinance AnalystCommented:
@yuppydu - apokigies, I hadn't realised it wasn't the question asked that had posted the sample. Should have looked more carefully.
WashcareAuthor Commented:
Thank you all, the selected solution works as I require. My appologies for the lack of detail in the opening question.
Not to worry Rob, it was quite evident...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.