| 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 |
| 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) | |||
Threaded Mode
