View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathryn Pundt Kathryn Pundt is offline
external usenet poster
 
Posts: 8
Default Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick, tota

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?