thanks Sandy

Will try your Excel formula

"ICU research" wrote:

I have two Dates and Times (Admission Date & Time) and Discharged Date &
Time). I need to calculate the number of bed nights (patient must be in the
unit at 00:00:00