This will work over midnight

=MOD(D1-A1-(C1-B1),1)

--
Regards,

Peo Sjoblom


"jasperPcuccumber" wrote in
message ...
CLR, you are truly a God among humankind.
One more and I will stop bugging you.

Trying to enter times so they will total hours for the day, forgot about
grave shift. Punch in at 23:00 (11pm) in cell a1 punch out at 2:00 (2am)
in
cell b1, in at 2:30am in cell c1 out at 6:00am in cell d1.

Conditional Format formula? If so what is it?

"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)