How do I find the maximum time value from a list

L

Lee

I'm having trouble locating the max time vaue from a list.
I have a list formatted as (hh:mm), whenever I use the Max function id
doesn't signify the hightest value. I've also tried using the Large Function
with 1 as the signifyer but this doesn't work either. eg
List: 2:45 3:00 0.75 1:00

Max(list) = 2:45
Large(list,2) = 3:00

How do I overcome this problem. Your help would be most appreacative

Lee
 
G

Gary

Its working on my system. Why do you have 0.75 in the list? that can be the
reason.

Gary
 
Top