Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Can anyone assist with the following?
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.
Can anyone help?
Thanks a million!
Jose
Hi Jose
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
/Dennis
Sorry Jose, but I see that I forgot somethin.
It should be IF(Endtime-Starttime<=MakeTime(0,10),red()) instead
Hi Jose
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
/Dennis
Dennis,
thanks a million! It worked!
Sorry Jose, but I see that I forgot somethin.
It should be IF(Endtime-Starttime<=MakeTime(0,10),red()) instead