31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!
Calculating length of stay
I know that in OC we are able to calculate the difference between two date fields and the same for time fields, but is there a way to combine the two?
What I am interested in calculating the length of hospital stay (in hours and minutes) for a subject using date of admission, time of admission, date of discharge, and time of discharge.
I have attached a sample calculation in Excel.