HI,
I'm trying to use a formula that determines the census in a room at any given hour. I have a test formula set up, but it is not returning correct values. For examples, in the 1/1/2013 rows, it should return ) because no one was using the room at that time. Please see attached file.
Bookmarks