MAXIFS & SUMIFS for time

[BlueMoose]

I am attempting to do MAXIFS and SUMIFS for durations of time; however, it's currently not doing it.

I have entered =MAXIFS(J2:J24901,A2:A24901,AH2) in order to get the highest duration on that given date and time period.  It works fine for the cells that aren't dealing in time; but, just gives me all zeroes when I try it with time.

[#2 · Accepted solution]

@BlueMoose 

Your times in J may be numbers stored as text.

Something like this maybe (In this example, I deliberately entered several of the times in an unrecognized format so Excel believes they're text) :

You could use an ISTEXT on J like this to check a few of them:

=ISTEXT(J2:J10)

If it comes back true, this article has a few ways to get Excel to evaluate them as numbers:

Convert numbers stored as text to numbers - Microsoft Support

[#3]

Perfect, that was exactly the problem. All your steps resolved the issue!

[#4]

Glad it worked!