Support Board
Date/Time: Sat, 01 Mar 2025 13:23:30 +0000
Post From: Restart Spreadsheet study base on Regular trading Hours (RTH)
| [2021-09-09 20:45:55] |
| Mario Escalante - Posts: 21 |
|
I'm using the following function: =IF(ISNUMBER(SEARCH("09:30",D1)),"1","0") my problem is that the SEARCH and FIND functions are for text only, so the formula won't return the desired value (1) tried converting the value to text format, does not work Any workaround for this problem? how can I set my spreadsheet study formulas to restart every day at 09:30 am. (RTH open) thank you for the help |