How do I find the maximum time value from a list

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time values for courses 2
HELP! I need to make an IF Statement comparing date/time fields.. 2
I need Time Range to return Value 4
Conditional Time Calculation 10
Find unique value in list (TIME), not working 2
Adding Times 7
Fill Values in List 4
Calculate the total overlapping time of multiple tasks, excluding non-working times 1

Top