max function returns 0 value

[randz77]

Hi,

Need your assistance. I'm getting 0 value for max function though I have committed it with array. value should in time format.

here's the formula that i used:

=MAX(IF($A3=Dump!$D$10:$D$260,Dump!$F$10:$F$260))

[FDibbins]

Try formatting that cell as Time. Excel wont necessarily automatically format it that way, so you may need to do it manually

hmm also, are you sure the data in F really is time, and not text that just looks like time? test with =isnumber(F10) False indicates text