Times in Excel
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
|