I need to create a formula that calculates the length of stay that invloves
date and times cells. For example:
C11 = date (admission date)
C12 = time (24 hour clock) (admission time)
C20 = date (discharge date)
C21 = time (24 hour clock) (discharge time)
C22 = total length of stay (time) in hours/min ie 72 hours 25 minutes

I had this completed initially with the date and time for admission and
discharge in one cell each. Which worked great. Now they want it broken
into a cell for the dates and a time for the cells.

Is what l am asking even doable. Any assistance would be greatly appreciated

Lynda S