Support Board
Date/Time: Wed, 27 Nov 2024 10:37:02 +0000
Post From: formula time
| [2023-09-03 15:17:20] |
| User278398 - Posts: 291 |
|
i understand the formula u wrote, but it is not what i wish for. i will be more specific: i have id1: spreadsheet formula study, and the formula i have in it: =1 also, i have id2: spreadsheet formula study, and the formula i have in it: =if(XXX,ID1.SG1,0) .... i want to get ID1.SG1, between 30-50 sec in every min. how "=INT(FRACTIME(FRACTIME(FRACTIME(NOW()) * 24) * 60) * 60)" can give me what i need !? can u help me with the specific formula (replace to "xxx") to get what i need? many thanks. |