| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to set the time as condition within if statement?
Does anyone know how to set the time as condition within if statement?
If(current time today's 5pm [after 5pm] and current time<today's 11:59 pm [before 11:59pm],true,false) Thank you for any suggestion Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to set the time as condition within if statement?
=IF(AND(NOW()TODAY()+17/24,NOW()<TODAY()+23/24+59/60/24),"true","false")
-- Allllen "Eric" wrote: Does anyone know how to set the time as condition within if statement? If(current time today's 5pm [after 5pm] and current time<today's 11:59 pm [before 11:59pm],true,false) Thank you for any suggestion Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to set the time as condition within if statement?
Thank you very much
Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Discussion (Misc queries) | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
| compare time in IF statement | Excel Worksheet Functions | |||
Linear Mode
