software

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

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

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