Thread: Times in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annie Annie is offline
external usenet poster
 
Posts: 103
Default 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