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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need a lot of help with MS Excel 2010 2
Calculate After hours 3
Calculating time for 3rd shift 4
Add time when working 3rd shift 0
Help with a formula for a Time Sheet. 1
TIME CALCULATION 8
work hours with different hour prices 12
Calculate the median value before a specified list 0

Top