| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check if a time is past a certain time
If i have a time entered in a cell say A1, how can i check if the time
is past a certain time say 5:00pm using an if statement? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check if a time is past a certain time
Or how can i check if the current time is past a certain time say 5pm?
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check if a time is past a certain time
On Sat, 31 Jan 2009 13:23:42 -0800 (PST), Savio
wrote: Or how can i check if the current time is past a certain time say 5pm? Try this: =IF(MOD(NOW(),1)TIME(17,0,0),"later than 17","not later than 17") Hope this helps / Lars-Åke |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check if a time is past a certain time
=IF(HOUR(A1)=17,"5 PM or later","Not yet 5PM") Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 31 Jan 2009 13:12:59 -0800 (PST), Savio wrote: If i have a time entered in a cell say A1, how can i check if the time is past a certain time say 5:00pm using an if statement? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Past Due/Completed on time date formula | Excel Discussion (Misc queries) | |||
| subtracting time going backwards past midnight? | Excel Worksheet Functions | |||
| Calculating time past midnight. | Excel Discussion (Misc queries) | |||
| Using date and time of past crimes to project the next occurance | Excel Discussion (Misc queries) | |||
| Calculating Time Past Midnight | Excel Worksheet Functions | |||
Hybrid Mode
