 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006How 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 Its working on my system. Why do you have 0.75 in the list? that can be the reason. Gary > 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 [quoted text clipped - 9 lines] > > Lee it shouldn't be 0.75 it should be 0:75 > Its working on my system. Why do you have 0.75 in the list? that can be the > reason. [quoted text clipped - 13 lines] > > > > Lee 0:75 as minutes? > it shouldn't be 0.75 it should be 0:75 > [quoted text clipped - 15 lines] > > > > > > Lee |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.