Over time.

[Swanie]

I am looking for a payroll formula, something like this
days hours
M 8
T 8
W 8
T 8.5
F 8.5

 

[Swanie]

Thanks Mike H. It works!!!

Hi,

Regulaer hours

=MIN(40,SUM(B1:B5))

overtime hours

=MAX(0,SUM(B1:B5)-40)

Mike