How do I find the maximum time value from a list
 

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

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

How do I find the maximum time value from a list
 

it shouldn't be 0.75 it should be 0:75


"Gary" wrote:

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

How do I find the maximum time value from a list
 

0:75 as minutes?

"Lee" wrote:

it shouldn't be 0.75 it should be 0:75


"Gary" wrote:

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