Time Sheet calculations

D

dkostel

Hi,
I'm creating a time card that lists time in the 12 hour am-pm fomat.
How do I calculate time between in and out (keeping in mind that there
will be overnight shifts).
Thanks-
Donna
 
J

John

If C contains the start time and D the finish time then place this in E
D3-C3+(D3 < C3) and format appropriately
 
Top