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
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!!!
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |