Over time.
Hi,
Regulaer hours
=MIN(40,SUM(B1:B5))
overtime hours
=MAX(0,SUM(B1:B5)-40)
Mike
"Swanie" wrote:
I am looking for a payroll formula, something like this
days hours
M 8
T 8
W 8
T 8.5
F 8.5
-------------
Reg 40
OT 1
------------
total 41
----------
I want the Reg hour Formula to have anything that is 40hours or less than
forty. i want the over time cell to have anything over forty and i would want
to have a formular adding the reg and and overtime. something like Regular
=40 or less than 40. Overtime = more than 40.
|