Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I am trying to calculate number of hours between 2 times. I am helping someone in a hospital. If a patient checks in at 18:00pm and checks out at 03:30am - how can I calculate the number of hours they were in the hospital. It will work within a 12 hour period for me but when it goes past midnight it won't work- I am just deducting one time from another - is there a different way??? Many thanks -- Kind regards Ann Shaw |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
A new Excel add-ins web-site | Excel Discussion (Misc queries) | |||
Entering Times In Excel | Excel Discussion (Misc queries) | |||
Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions |