Forum Discussion
Solved
MAXIFS & SUMIFS for time
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.
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
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
- Perfect, that was exactly the problem. All your steps resolved the issue!
- Glad it worked!
