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?