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]

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

[Sxbbb]

 result is like this which is still not correct 

[SunilChauhan]

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

[Sxbbb]

No, in case the minute is 00.

[SunilChauhan]

00 should coms unders <10 minute. whats wrong with it?

[Sxbbb]

Its value is 1hr 6s which exceeds 10 minutes should be green.

[SunilChauhan]

ok.try this

if( subfield(Time#([Over Time Machine],'hh:mm:ss'),':',2)<10  and subfield(Time#([Over Time Machine],'hh:mm:ss'),':',1)<1,

red(),rgb(50,205,50))

[Sxbbb]

The value came out right, thank you very much.

[SunilChauhan]

Close this post by accepting as solution. moreover you may like the post if you want 🙂

[Sxbbb]

What if I want from 11 minutes to 20 minutes in yellow?