Excel Timesheet minimum hours

[KORKNEY]

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

 

[steve the fish]

This entered CTRL-SHIFT-ENTER not just ENTER should work. It WILL get the wrong answer if not entered correctly:

=SUM(IF(B3:F3<>"",IF(B3:F3>6,B3:F3,6)))

 

[KORKNEY]

Perfect, thank you