find days and hours between 2 sets of dates and times

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between dates/times in Days & Hours 2
Calculating elapsed days and hours 4
how can we calculate the numbers of hours between two dates and 4
calulate working hours and minutes between 2 dates and times 9
Calculate times between dates and times in Excel 1
Number of hours between now and selected date 5
Hours between dates 11
Calculating diff between date/ time only between certain hours 5

Top