Over time.
 

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.

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.

Over time.
 

Thanks Mike H. It works!!!

"Mike H" wrote:

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.