| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need Time Range to return Value
You are a pro my friend thank you so much. On Friday, October 18, 2013 3:33:36 PM UTC-5, Claus Busch wrote: Hi Eric, Am Fri, 18 Oct 2013 13:28:30 -0700 (PDT) schrieb Eric Ocasio: Thanks you so much, this really help. Only have one issue, on the blank cells it is giving me "Third" instead of a blank cell. Any ideas? then try: =IF(B2="","",IF(AND(B2=TIME(7,,),B2<TIME(15,,))," First",IF(AND(B2=TIME(15,,),B2<TIME(22,,)),"Secon d","Third"))) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| drop first row in range and return a new range object | Excel Programming | |||
| I need to return the lowest time value in a range of cells. | Excel Worksheet Functions | |||
| Return Range Address from Active Range | Excel Programming | |||
| use the current time to return a value | Excel Discussion (Misc queries) | |||
Threaded Mode
