Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create a formula
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I create a formula for Salutation | Excel Discussion (Misc queries) | |||
Create Formula for calculating Little League Age... | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |