| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you enter a formula in a cell to run a macro? | Excel Worksheet Functions | |||
| Am trying to make a time sheet and having problems with a formula. | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
| Excel Time Duration Formula | Excel Worksheet Functions | |||
Linear Mode
