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

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
Asked:
Washcare
1 Solution
 
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.
0
 
yuppyduCommented:
Is this what you need?
time.xlsm
0
 
Rob HensonFinance AnalystCommented:
What seems to be the problem?

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

Rob H
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
barry houdiniCommented:
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
 
yuppyduCommented:
Hi Barry, cannot compete with you. Still using some of the magical formulas you gave me time ago.
0
 
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.
0
 
WashcareAuthor Commented:
Thank you all, the selected solution works as I require. My appologies for the lack of detail in the opening question.
0
 
yuppyduCommented:
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now