I have to dimensions that display time. Dimension1 displays start time.
Dimension2 displays end time.
I am drafting a summary table for activity time. I would like format a table in such a way that if Dimension2 is equal or less that 10minutes, it highlights in red.
What is the format of the times? Just standard hh:mm:ss?
In that case, you can just make a expression like this: if(time(Endtime-Starttime)<=maketime(0,10) ,red())
Then you can use that expression in either the "Background color expression" or the "Text color expression" of the endtime, in your case the Dimension2.
If you want an other color that the standard red color that the function red() gives you, then you might use the RGB() function instead
What is the format of the times? Just standard hh:mm:ss?
In that case, you can just make a expression like this: if(time(Endtime-Starttime)<=maketime(0,10) ,red())
Then you can use that expression in either the "Background color expression" or the "Text color expression" of the endtime, in your case the Dimension2.
If you want an other color that the standard red color that the function red() gives you, then you might use the RGB() function instead
