if statements with Hours and minutes

[anuradhaa]

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

[jonathandienst · Accepted solution]

This will do it:

=If(Frac(ReloadTime()) *24 > 6.5, 'Y', 'N')

[Kushal_Chawda]

=if(Time(ReloadTime(),'hh:mm') > time#('06:30','hh:mm'), 'Y','N') as TimeFlag

[todtliat01]

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')

[anuradhaa]

Thanks jonathan