Subtract a half hour from a field If it's value is greater than 6 hrs 2

[JSD]

Hello

I am working with a db that employees use to clock in and out of jobs for production/ efficiency tracking. I don't want them to have to take time to clock out for lunch. Is there a way to maybe create a calculated field that subtracts one half hour from another field called 'act hrs' if the value in 'act hrs' is greater than 6? Any ideas will be helpful as usual.

Thanks

Jeremy

 

[SteveR77]

Jeremy -

Are the values numeric or are they date/time?


Steve

 

[JSD]

SteveR77,

Hello. I have two date/time fields that I subtract in a calculated field to get the 'act hrs' value, which is numeric. I would need to subtract one half hour from the 'act hrs' value, If the value is greater than 6 hrs.

Thanks for your time

Jeremy

 

[sirace]

Not sure if I can help, but would something like this work?

IIf([act hrs]>6, [act hrs]-.5, [act hrs])

 

[SteveR77]

Jeremy,

sirace's IIF statement should do the trick for you. I just wanted to be sure if I posted a statement it would work for you.


Cheers,


Steve