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.