I am analysing data from an Critical Care unit on drug usage. I have cells that state the duration of time that a patient was on the unit in Days and Hours (dd-hh) "x days y hours". Over the period of time on the unit I also have the amount of drug used in mLs, entered as a number in a Cell.
I want to be able to determine the amount of drug used per day during their stay, as mLs/hr.
Currently, I am unable to find the appropriate function and formula to calculate this neatly. I attach an example Spreadsheet if this helps.
Any help would be greatly appreciated.
Bookmarks