Problems of countif by row have been resolved in the attached spreadsheet, but I still can't get it to total the hours worked. I've used an array formula kindly provided by a viewer and while I can see in principle how it should work, I can't get it to actually work.
ANy help gratefully received.
Thanks
Hi Bob,
Hopefully this helps you out...
In C17, change the formula to:
=SUM(IF($B9:$N9="DAY",ABS($D9:$P9-$C9:$O9)))
It's still an array formula, so use CTRL+SHIFT+ENTER. Fill that down to C21. Format those cells as: [h]:mm (You currently have just "h:mm", which resets at 0 for each 24-hour period.)
Change the formula in E17 to:
=SUM(IF($B9:$N9="NIGHT",ABS($D9:$P9-$C9:$O9))) and fill it down to E21 (again, array formula).
For the holiday hours, use the formula in F17:
=SUM(IF($B9:$N9="Holiday",ABS($D9:$P9-$C9:$O9))) (array, and filled down to F21).
Hi Paul
Thanks a lot - I now see I had the format wrong (despite being clearly instructed!).
Much appreciated
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks