Excel Timesheet minimum hours

KORKNEY

New Member
Joined
Jul 31, 2018
Messages
2
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

Well-known Member
Joined
Oct 20, 2009
Messages
7,829
Office Version
365
Platform
Windows
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)))
 

Forum statistics

Threads
1,085,543
Messages
5,384,341
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top