QuChe Yvonne
Registered User.
- Local time
- Today, 04:33
- Joined
- Oct 17, 2012
- Messages
- 11
OT Hrs: IIf([Production Details]![Depositing Qty Overtime]<30,"0",Round(([Production Details]![End Time]-[Production Details]![End Work])*24,2))
The result was show properly. But when I used it the OT Hrs to multiply the OT quantity. The answer correctly calculation execpt the OT value was 0. The error show as #Num!.
Anyone could help for this? Thanks in advance.
The result was show properly. But when I used it the OT Hrs to multiply the OT quantity. The answer correctly calculation execpt the OT value was 0. The error show as #Num!.
Anyone could help for this? Thanks in advance.