Linked CSV file, date format error, #Num! ... (1 Viewer)

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.
 

Users who are viewing this thread

Top Bottom