OT hours as AM/PM? Frankly that doesn't make any sense at all, what if you
have 20 hours of OT, are you going to use 08:00 PM? If you mean what you put
into the cells to be calculated like

IN Out
08:00 AM 11:30 AM

and so on, that is just a formatting issue. Just change the format



--
Regards,

Peo Sjoblom


"Kathryn Pundt" wrote in message
...
The timesheet is perfect, except for the fact that now our accounting
department wants the times to be AM/PM, not military. Can we still
calculate
the total times and convert the time to AM/PM to comply with the "heads"?
Example: in 8:00 AM / out 12:00 PM / in 1:00 PM, etc.

"Toppers" wrote:

Assuming the mismatch between your formula and rows is typo (row 12
contains
headings), the formula works OK for me. I have the time columns formatted
as
hh:mm and Reg Hours as General


OT hours (formatted as General):

=MAX(0,(($D12-$C12)+($F12-$E12)+($H12-$G12))*24-8)

What error do you get?

HTH


"Kathryn Pundt" wrote:

I downloaded a timesheet like the one below. I added the extra in/out
and
can't seem to get the formulas to work. I used the existing formula
and just
added the two new columns.
=IF((((D12-C12)+(F12-E12)+(H12-G12))*24)8,8,(((D12-C12)+(F12-E12)+(H12-G12))*24))

B C D E F G H I J
K
L M N
12 Day In Out In Out In Out Reg Hrs OT Sick Holi Vac Total
13 Sunday 0.00
14 Monday 0.00
15 Tuesday 0.00
16 Wednesday 0.00
17 Thursday 0.00
18 Friday 0.00
19 Saturday 0.00
20
21 Total 0.00 0.00 0.00 0.00 0.00 0.00

Can someone help me figure out what I am doing wrong?