I am trying to do this calculation but it doesn't work. It is yielding a negative number when the day_of_wk - "2". Can someone help? Thank you.
pre: IIf([day_of_wk]="1",([time]-[reg_time])/60,IIf([time]<0,([time]-[reg_time])/60+24,IIf([day_of_wk]="2",([time])/60,IIf([time]<0,([time])/60+24))))
pre: IIf([day_of_wk]="1",([time]-[reg_time])/60,IIf([time]<0,([time]-[reg_time])/60+24,IIf([day_of_wk]="2",([time])/60,IIf([time]<0,([time])/60+24))))
