View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kate
 
Posts: n/a
Default total work hours for 24 hour on-call schedules

I am trying to create a time sheet for hospital residents who are sometimes
on call for 24 hours. If they enter 07:00 as their start time, and 07:02 for
their end time, I get a total of 2 minutes worked, when in reality they have
worked 24 hours and 2 minutes. How do I create a formula to correct this?

Thank you,
Kate