Want to add red in less than 10 minutes

[Sxbbb]

If the time is less than 10 minutes, you want it to be green.

Now I tried the code : if(Time#([Over Time Machine],'hh:mm:ss') < Time#('00:10:00','hh:mm:ss') ,rgb(50,205,50))

but the result is like this which is still not correct

Want to add red in less than 10 minutes

[SunilChauhan]

minute ( '09:14:36' )   return 14   use this function

if(Minute(Time#([Over Time Machine],'hh:mm:ss')) < 10,rgb(50,205,50))

[NiTo]

Hi Sunil.

I use the coding and it do gives the green color for the duration less than 10 mins but it do replace the timings with rgb(50,205,50)). I replaced it with the proper field, Over Time Machine, but than it gives the time in decimal format..

How to rectify it?

thanks

[SunilChauhan]

use   if(Floor(Minute(Time#([Over Time Machine],'hh:mm:ss')) )< 10,rgb(50,205,50))

[NiTo]

Hi,

Still showing rgb(50,205,50) instead of duration.

[SunilChauhan]

ok use this expression  in Color

if(Floor(Minute(Time#([Over Time Machine],'hh:mm:ss')) )< 10,rgb(50,205,50))

and this in  expression

Time#([Over Time Machine],'hh:mm:ss')

[NiTo]

Oh Yeah..

This works.

Thanks a lot Sunil.

[SunilChauhan]

Great ! mark this as a solution  to close this thread.

[NiTo]

Hi,

Query was posted by another user, i think that is why I am not getting an option to mark it as a solution.

[Sxbbb]

I tried the code : if(Minute(Time#([Over Time Machine],'hh:mm:ss')) < 10,rgb(50,205,50))

but the result is like this which is still not correct

want to add red less than 10 minutes