| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine if time is within a windoww
need a formula to determine if en event time is within a given window. Cell 1 has window start time. Cell 2 has window end time. Cell 3 has event time.. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window...
any help would be great! Thanks Travis |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine if time is within a windoww
On Tuesday, January 20, 2015 at 5:59:10 PM UTC-5, travis wrote:
need a formula to determine if en event time is within a given window. Cell 1 has window start time. Cell 2 has window end time. Cell 3 has event time. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window... any help would be great! Thanks Travis Also, cell time format is 1/9/2015 11:59:00 PM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine if time is within a windoww
Hi,
Am Tue, 20 Jan 2015 14:59:07 -0800 (PST) schrieb Travis: need a formula to determine if en event time is within a given window. Cell 1 has window start time. Cell 2 has window end time. Cell 3 has event time. Want cell 4 to read "in" or "out" dependent on the event time being inside or outside of the specified window... try: =IF(AND(C1A1,C1<B1),"in","out") Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine Resource Allocations by evaluating available time and required time. | Excel Worksheet Functions | |||
| How can I determine and display my Time Zone? | Excel Discussion (Misc queries) | |||
| how can I add time in excel to determine how long something took? | Excel Worksheet Functions | |||
| I need to use area code to determine time zone | Excel Discussion (Misc queries) | |||
| Determine elapsed time between two dates | Excel Programming | |||
Hybrid Mode
