Hello,
I was hoping someone could assist in correcting this expression. I am attempting to calculate the total number of hours minus the lunch break, and convert it to hour format.
Total Hours: DateDiff("n",[ShiftStart],[EndShift])+([Total Lunch])/60
I was hoping someone could assist in correcting this expression. I am attempting to calculate the total number of hours minus the lunch break, and convert it to hour format.
Total Hours: DateDiff("n",[ShiftStart],[EndShift])+([Total Lunch])/60