Hello,
I use excel common formulas often but am a neophyte when it comes to more complex formulas. I am working on a Recovery Room staffing project for a Director of Nursing. She wants to know the the number of patients in her rocovery room at hour intervals. I want to be able to count that between 8:00-8:59 there were x number of patients in Recovery and so on etc for the different hour intervals for a day. I have attached a sample spreadsheet. Feel free to change around what ever you want. Can you also explain what the parts of your formula are doing so I can learn how to do it for other projects?
Thanks in advance for you help, I love this forum!
Jason
Bookmarks