ExcelBanter - How do I enter a time formula into a worksheet that determines if.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I enter a time formula into a worksheet that determines if. (https://www.excelbanter.com/excel-discussion-misc-queries/13170-how-do-i-enter-time-formula-into-worksheet-determines-if.html)

Lee

How do I enter a time formula into a worksheet that determines if.

How do I, set about entering a formula within a worksheet that determines if
the Time is greater or less that the time in a certian cell;
eg =if(now()K17,"then display this","") K17 holding the Value 08:30 AM
formated to time

Jason Morin

=IF(MOD(NOW(),1)K17,"then display this","")

HTH
Jason
Atlanta, GA

-----Original Message-----
How do I, set about entering a formula within a
worksheet that determines if
the Time is greater or less that the time in a certian
cell;
eg =if(now()K17,"then display this","") K17 holding
the Value 08:30 AM
formated to time
.

All times are GMT +1. The time now is 08:41 AM.