Login Page - Create Account

Support Board


Date/Time: Sat, 01 Mar 2025 13:16:26 +0000



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

[2021-09-09 22:23:44]
Sawtooth - Posts: 4177
If you have a bar with the 09:30:00 timestamp, you could use this:
=MROUND(FRACTIME(A3),1/86400000)=TIMEVALUE("09:30:00")

If the 09:30:00 bar is the first bar of a new day, you could use this:
=INT(A3)>INT(A4)