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 95
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