Hi Browun and welcome to the forum.
What was this guy smoking when he wrote that formula???
Why would a person ever use Mod(.. , 1)??
So in this problem you need to add 1 if a person is working between two consecutive hours that are in Column B.
The first part of the formula in D29 is easy enough when it shows..
WAIT, WAIT... this returns True or False for all the D5 to D18 cells. You can't add or multiply True or false, they need to be turned into NUMBERS.
This is a common problem when using SumProduct and us normal Guru's change this True/False stuff to numbers by taking the negative or the negative of it. We use:
It looks like the formula you have used the MOD(.., 1) function to turn those things into numbers....
Try this formula in D29 instead of the one you have above and pull it down. Then test it by putting some start and end numbers in column D and E.
Bookmarks