total work hours for 24 hour on-call schedules

K

Kate

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
 
P

Peo Sjoblom

If you want to exceed 24 hours you need to use both the date and the time in
start and end times

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top