| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | New Users to Excel | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Hybrid Mode
