View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary
 
Posts: n/a
Default How do I find the maximum time value from a list

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

Gary
"Lee" wrote in message
...
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