Calculation valid from specify time (1 Viewer)

[QuChe Yvonne]

I wish to create a query : Only calculation OT start from 6:00pm, but it not working with below. Please advice. tks.
OT : IIf([Production Details]![End Time]>18,0,Round(([Production Details]![End Time]-[Production Details]![End Work])*24,2))

 

[pr2-eugin]

What is the Data type of [Production Details]![End Time] is it Date/Time then make sure that it is surrounded by ## also use the proper format.. Could you show one sample data, as it is in the table and what is the result that you wish to see.?? Without that it is a bit hard to give a right answer..

 

[QuChe Yvonne]

Hi Paul Eugin,

I have attached the sample. I can the calculation OT started from 6:00pm. For those didn't overtime show 0.

Please advice.

Thanks
Yvonne

 

[pr2-eugin]

There is no Query in the DB, there is only one table.. Show us what you have done so far, atleast show sample data result.. so that we can start guiding you how to get there..