Format Rules column Time /Duration

Hi everyone!!!
other problem!!
I’m trying to create a Format Rules.
I have a column called “F” type duration which makes me the difference between two time columns, and a column called “Target F” with type Time.
Column “Target F” always has a fixed value for example 00:23:00, while column “F” can vary.
I entered this formula that colors a data red but it doesn’t work, it colors all the data red.
[F]> [Target F]
Example if “F” is greater than 00:23:00

0 2 96
2 REPLIES 2

Please try making [Target F] 's fixed value as “000:23:00” instead of “00:23:00”. If you are having this fixed value in the column’s settings and not reading from spreadsheet, please ensure to include it in double quotes.

Edit: “000:23:00” converts the value to a duration. “00:23:00” denotes a time value. One reason of your current comparison failing is because a duration value [F] is being compared with time (“00:23:00”)

THANKS A LOT!!!

Top Labels in this Space