MIN function not working

[gavin]

I have a column of times formatted with the custom format of:

custom format - dd "days" hh "hours" mm "minutes"


I need to find the maximum and minimum times in the column.



=MAX(F2:F500) returns 01 days 16 hours 19 minutes



=MIN(F2:F500) should return 00 days 00 hours 05 minutes but in fact the cell
containing the formula has no value.


Any ideas what could be wrong? Any help gratefully appreciated.



Gavin

 

[Frank Kabel]

Hi
how did you format the resulting cell?

 

[gavin]

Hi Frank,
I used the Format Painter and copied the format from the result cell for the
MAX function - and that one is working, it returns 01 days 16 hours 19
minutes (which is correct).


Regards,



Gavin

 

[Dave Peterson]

If you select the cell with the =min() formula, then hit F2, then F9, what's in
the formula bar?

(Hit escape to get the formula back--or edit|undo if you left the cell.)

 

[gavin]

Maybe there's another way of achieving this?


Regards,


Gavin