Hi
Is the above code correct? if not what is the correct way to use?Code:IIf((IIf(((Sum([Actual_Hours]))*24<20),(Sum([Actual_Hours])),CStr((Int(Sum([Actual_Hours])*24) & ":" & Round(((Sum([Actual_Hours])*24)-Int(Sum([Actual_Hours])*24))*60,1)))))>=20,20,(IIf(((Sum([Actual_Hours]))*24<20),(Sum([Actual_Hours])),CStr((Int(Sum([Actual_Hours])*24) & ":" & Round(((Sum([Actual_Hours])*24)-Int(Sum([Actual_Hours])*24))*60,1))))))