Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pie Chart Sectional Pull-outs | Charts and Charting in Excel | |||
how do I add words, holiday =1, holiday am=0.5 | Excel Worksheet Functions | |||
Print outs from Excel has symbols instead of words | Excel Discussion (Misc queries) | |||
How do i copy numbers from Web and paste to excel and and get tota | Excel Worksheet Functions | |||
Holiday Planner show holiday taken? | Excel Worksheet Functions |