Forum Discussion
Excel Formula
The problem I am trying to solve is... Over a single day i have two data columns, one is a staff start time and the other is staff end time. What I want to do is ascertain how many staff are pres...
Hi Sergei
Yes it should be 6, 5 is incorrect. I copied and pasted your formula, changed the cell addresses to match where my data is sitting, but I am still getting 7 in at 9am when it should be 6. I am doing something wrong
Yes it should be 6, 5 is incorrect. I copied and pasted your formula, changed the cell addresses to match where my data is sitting, but I am still getting 7 in at 9am when it should be 6. I am doing something wrong
Peter, please be sure you correctly changed addresses keeping logic of absolute and relative references. Another point is < instead of <=, etc. Have no idea what else could be.
- Thanks Sergei, in your illustration column J looks correct, is that based on the formula you are showing