| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need Time Range to return Value
I need to get a Value Based on Start time.
If the Start time is between 7:00 and 14:59 = First If the Start time is between 15:00 and 21:59 = Second If the Start time is between 22:00 and 6:59 = Third Values will show in Column "D" A B C D 1 Name Start End Shift 2 John Doe 8:00 17:00 Value? Any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need Time Range to return Value
Hi Eric,
Am Fri, 18 Oct 2013 13:07:47 -0700 (PDT) schrieb Eric Ocasio: A B C D 1 Name Start End Shift 2 John Doe 8:00 17:00 Value? try in D2: =IF(AND(B2=TIME(7,,),B2<TIME(15,,)),"First",IF(AN D(B2=TIME(15,,),B2<TIME(22,,)),"Second","Third")) and copy down Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need Time Range to return Value
Hi Claus
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? On Friday, October 18, 2013 3:14:55 PM UTC-5, Claus Busch wrote: Hi Eric, Am Fri, 18 Oct 2013 13:07:47 -0700 (PDT) schrieb Eric Ocasio: A B C D 1 Name Start End Shift 2 John Doe 8:00 17:00 Value? try in D2: =IF(AND(B2=TIME(7,,),B2<TIME(15,,)),"First",IF(AN D(B2=TIME(15,,),B2<TIME(22,,)),"Second","Third")) and copy down Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need Time Range to return Value
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 |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
