Hello Narayan,
Well, the reassuring thing for me is that I used exactly this formula.(for patients that arrived and left on the same day because when they arrive at 9pm and leave at 2am, then I use another formula) so ok, I may have exagerated, it is not very lenghty but, I just thought there...
Hi Narayan,
First, thank you for your input.
But, if I understand the blogpost correctly, the contionnal formatting would replace the least problematic part of my problem. When the data is there, creating the bargraph is not the problem.
My data is like this
Time of arrival Time...
Hello everyone,
This question is one that I have quite often when I do data analysis at my job :
I am very often working with data concerning time of arrival / time of departure of patients.
I want to do bar graph of the number of patients actually there during each one hour period.
Exemple...