Ok another one Chuck.
We have some employees who work swing and grave. They punch in before
midnight and sometimes out for lunch before midnight sometimes after. They
may or may not finish the shift after midnight. I need a conditional format
formula that will differentiate between the two.
Can you help????

"CLR" wrote:

Total hours in A1
In B1 put =MIN(A1,40)..........this is Straight time hours
In C1 put =IF(A140,A1-40,0)...........this is OT hours

Vaya con Dios,
Chuck, CABGx3


"jasperPcuccumber" wrote in
message ...
I need to break down the hours only into straight time and ot. If A1 is
32
hours total time then C1 should show "0" over time hours. If A1 is 42
hours
total then C1 should show"2" overtime hours. I can't figure out how to
create this formula.

"CLR" wrote:

Total hours in A1
Rate per Hour in B1
In C1 put this formula......copy down if desired..........

=IF(A1<=40,A1*B1,(40*B1)+((A1-40)*B1*1.5))

Vaya con Dios,
Chuck, CABGx3



"jasperPcuccumber" wrote in
message ...
I am setting up a payroll worksheet. I need a cell to show total
hours,
one
for regular time and one for over time. What formatting or formula
can I
use
to figure over time and straight time based on 40 overtime rule?
(anything
over 40 hours in a week is overtime)