Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if( subfield(Time#([Over Time Machine],'hh:mm:ss'),':',2)<10 and subfield(Time#([Over Time Machine],'hh:mm:ss'),':',1)<1,
red(),
if( subfield(Time#([Over Time Machine],'hh:mm:ss'),':',2)>=11 and subfield(Time#([Over Time Machine],'hh:mm:ss'),':',2)<=20 and subfield(Time#([Over Time Machine],'hh:mm:ss'),':',1)<1, Yellow(),
rgb(50,205,50)))