• Status: Solved
• Priority: Medium
• Security: Public
• Views: 557

# 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
Etc
Etc
Etc
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

David
0
Washcare
1 Solution

EngineerCommented:
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.
0

Commented:
Is this what you need?
time.xlsm
0

Finance AnalystCommented:
What seems to be the problem?

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

Rob H
0

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

=SUMIF(G:G,J5,H:H)

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
0

Commented:
Hi Barry, cannot compete with you. Still using some of the magical formulas you gave me time ago.
0

Finance AnalystCommented:
@yuppydu - apokigies, I hadn't realised it wasn't the question asked that had posted the sample. Should have looked more carefully.
0

Author Commented:
Thank you all, the selected solution works as I require. My appologies for the lack of detail in the opening question.
0

Commented:
Not to worry Rob, it was quite evident...
0
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.