HI

I need help in using IF function. according to the worksheet, normal hours is 8 hours per day Monday to Friday. can anyone help me with the function to calculate normal hours in 1 cell.

thanks
sanjeshniNORMAL HOURS.xls