| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate difference between dates and times
I need to set up a spreadsheet where the nurses will be typing in the date
and time of an assault and the date and time of an exam. I need the spreadsheet to calculate the amount of hours that have passed between the two dates. So if the victim was assaulted on 02/24/06 at 9:00 PM and comes into the hospital for an exam on 02/26/06 at 11:30 AM, I need to know how much time in hours has passed between the day and time of the assault and the examination. I am working on Excel 2000. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| calculate elapsed time between dates and times | Excel Worksheet Functions | |||
| Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
| Difference between 2 times and dates | Excel Worksheet Functions | |||
| Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) | |||
Threaded Mode
