Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continuous Evaluation of Time Function NOW() ??
Hi;
1) The following formula returns TRUE or FALSE: =AND($J$15<"",(MOD(SECOND(NOW())-1,6)+10) = COLUMN()) It works fine as long as the w/b is busy doing something! 2) Otherwise if the w/b is not busy, the formula appears to be calculated only ONCE at the current time NOW(), and F9 must be pressed repeatedly to re-calculate the formula despite Tools::Options::Calculation is set to Automatic. 3) Is it possible to have NOW() representing a progressive NOW() ?? 4) If not, can the above formula be modified such that it is evaluated continually for, say, the next 60 or 120 seconds from the current NOW() ?? Your expert advice would be greatly appreciated. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Continuous Evaluation of Time Function NOW() ??
If you wanted something like that, you would need a timer in the background
firing off a sheet calculation, something like this Sub Recalc() Static myCounter As Long If myCounter 60 Then Exit Sub myCounter = myCounter + 1 ActiveSheet.Calculate Application.OnTime Now + TimeSerial(0, 0, 1), "Recalc" End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "monir" wrote in message ... Hi; 1) The following formula returns TRUE or FALSE: =AND($J$15<"",(MOD(SECOND(NOW())-1,6)+10) = COLUMN()) It works fine as long as the w/b is busy doing something! 2) Otherwise if the w/b is not busy, the formula appears to be calculated only ONCE at the current time NOW(), and F9 must be pressed repeatedly to re-calculate the formula despite Tools::Options::Calculation is set to Automatic. 3) Is it possible to have NOW() representing a progressive NOW() ?? 4) If not, can the above formula be modified such that it is evaluated continually for, say, the next 60 or 120 seconds from the current NOW() ?? Your expert advice would be greatly appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic evaluation of custom worksheet function | Excel Worksheet Functions | |||
Continuous dates and time | Charts and Charting in Excel | |||
Sum function for non-continuous range | Excel Worksheet Functions | |||
Options Evaluation | Excel Worksheet Functions | |||
continuous cell function | Excel Worksheet Functions |