=(C20-C11)+(C21-C12)

and format as [h]:mm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lynda S" wrote in message
...
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