Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have taken reload hour and minutes using below expression.
Time(Frac(ReloadTime()),'hh:mm')
Now i want to check that hour and minute with pre define minutes
If that Time(Frac(ReloadTime()),'hh:mm') value is grater than 06:30 i want to say 'Y' and else 'N'
Thanks
This will do it:
=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')
This will do it:
=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')
=if(Time(ReloadTime(),'hh:mm') > time#('06:30','hh:mm'), 'Y','N') as TimeFlag
This way you can change the time limit as well
if(Num(Time(Frac(ReloadTime()),'hh:mm'))>Num(Time(Frac('06:30'),'hh:mm')), 'Y', 'N')
Thanks jonathan