Login Page - Create Account

Support Board


Date/Time: Fri, 27 Jun 2025 20:08:43 +0000



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

[2021-09-09 22:23:44]
Sawtooth - Posts: 4231
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)