| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
get HOUR check from NOW() cell
hi, not good with date, times, cannot get out of help, want to test for cell
is x hours past cell that has been updated with NOW(). e.g.: cell M9 with NOW(): 2008-05-27 2:00:00 AM =IF(current time is 2 hoursM9,0,1) would suggest help file have example how to manipulate NOW(). trying: =TRIM(LEFT(M9,SEARCH(" ",M9,12))) gets a value error/ might make to big a formula. would think easier way to manipulate this data. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract 1 hour from one cell and input it another? | Excel Worksheet Functions | |||
| Cannot check the check mark box in cell | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| convert decimal numbers to a fraction of an hour for payroll hour | Excel Worksheet Functions | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
Threaded Mode
