Login Page - Create Account

Support Board


Date/Time: Sat, 01 Mar 2025 13:19:37 +0000



Post From: Restart Spreadsheet study base on Regular trading Hours (RTH)

[2021-09-13 16:47:38]
Mario Escalante - Posts: 21
Tried #2 post, first suggestion unsuccessfully.

RESOLVED USING THE FOLLOWING FORMULA:

=IF(FRACTIME(A3)=TIME(09, 30, 00,0),1,0)

that will give you a (1) value everyday @ 09:30:00am

Thanks.
Date Time Of Last Edit: 2021-09-13 16:48:37