Login Page - Create Account

Support Board


Date/Time: Tue, 04 Mar 2025 10:38:44 +0000



Post From: Inconsistent calculations with Spreadsheet study

[2021-11-18 16:13:13]
Mario Escalante - Posts: 21
Good day, SC team,

I've been using the following formula in K3 in order to differentiate every new RTH section by returning a "1" at 09:30 am

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

somedays it works somedays it doesn't, IT IS INCONSISTENT

can I do something to resolve this? if not, is there any other way to restart my spreadsheet study every day at 9:30 am?

thank you for your help