Forum Discussion
MAXIFS & SUMIFS for 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!
