Hi,
Sorry bit of a newbie here!! I am making up a new timesheet for one of the departments in my company. Employees in this department get a guranteed payment of 6 hours per day, even if they dont work 6 hours that day so i have used the formula =IF(B3<6,6,B3)+IF(C3<6,6,C3)+IF(D3<6,6,D3)+IF(E3<6,6,E3)+IF(F3<6,6,F3) to calculate the minimum hours for the week. However if one of the total hours worked colums are blank if an employee hasnt been at work that day i don't want to count any hours for that day, please can you advise how i would do this? Many Thanks
Sorry bit of a newbie here!! I am making up a new timesheet for one of the departments in my company. Employees in this department get a guranteed payment of 6 hours per day, even if they dont work 6 hours that day so i have used the formula =IF(B3<6,6,B3)+IF(C3<6,6,C3)+IF(D3<6,6,D3)+IF(E3<6,6,E3)+IF(F3<6,6,F3) to calculate the minimum hours for the week. However if one of the total hours worked colums are blank if an employee hasnt been at work that day i don't want to count any hours for that day, please can you advise how i would do this? Many Thanks