| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find days and hours between 2 sets of dates and times
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find days and hours between 2 sets of dates and times
You'll find quite a few date/time functions at the following URL:
http://www.cpearson.com/excel/datearith.htm -- Kevin Backmann "The Auditor" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding dates and times | Excel Discussion (Misc queries) | |||
| how do I count a rota with no dates and using 24 hours clock | Excel Worksheet Functions | |||
| Find project start and end dates in a DB with many different proje | Excel Worksheet Functions | |||
| Stumper WORKDAYS Problem | Excel Discussion (Misc queries) | |||
Linear Mode
