Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Fri, 27 Sep 2024 07:20:09 +0000

Post From: When comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the =

[2021-08-08 18:18:54] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4092
In a spreadsheet study, when comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the = However, When comparing the same FRACTIME to the same TIMEVALUE, the > operator is accurate. When comparing the same FRACTIME to the same TIMEVALUE, the = operator is accurate. Formula Details of the inaccurate >= operator: [ >= ] K94>=TIMEVALUE("17:00:00") = 0 (number, integer)   [ K94 ] K94 = 0.7083333333333333 (number, double)   [ TIMEVALUE ] TIMEVALUE("17:00:00") = 0.7083333333333334 (number, double)     [ "17:00:00" ] "17:00:00" = "17:00:00" (text) K94 contains this formula: =MROUND(FRACTIME(A94),1/86400) M94 = 1 N94 should also be 1. See pic for reference. See .scss for more. Please advise.
0x Thank you
GreaterThanOrEqualTo.scss - Attached On 2021-08-08 18:17:13 UTC - Size: 1.19 MB - 204 views GreaterThanOrEqualTo.PNG / V - Attached On 2021-08-08 18:17:25 UTC - Size: 22.39 KB - 195 views