software

Need to calculate exact length of stay a patient has stayed on a ward by
subtracting date and time of admission from date and time of discharge.
Answer preferably in days and to nearest number of hours. Using Excel 2003.
Thanks for any help - will save me hours of time.

You'll find quite a few date/time functions at the following URL:

www.cpearson.com/excel/datearith.htm
--
Kevin Backmannquot;The Auditorquot; wrote:

gt; Need to calculate exact length of stay a patient has stayed on a ward by
gt; subtracting date and time of admission from date and time of discharge.
gt; Answer preferably in days and to nearest number of hours. Using Excel 2003.
gt; Thanks for any help - will save me hours of time.