Support Board
Date/Time: Tue, 26 Nov 2024 18:30:03 +0000
Post From: formula time-counting issue
| [2023-11-19 07:23:20] |
| User278398 - Posts: 291 |
|
hello, by second(now()) i can make triger between 0-60 sec (every 1 min the counter become to 0) ( for exa:, if i want to get triger at every 23 sec in each min so: =if(second(now())=23,1,0) )... I'm trying to figure how can i triger, every 4 min and 23 sec. (i want to get triger at 9:34:23,after that the next triger is at 9:39:23 (every 5 min the counter become to 0) ) 1. how can i triger by a similar way (by counting over time) ? 2. other way? thank you? |