| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find time and text
Can anyone tell me what is wrong with this function:
{=FIND(--SMALL(--LEFT(B18:B21,4),1),B18:B21)} returns #Value The range B18:B21 contains a list of times and names (10:15 John s) I want to return the contents both time and text of the one with the earliest time! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| How can i find time in various time zone? | New Users to Excel | |||
| convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Threaded Mode
