Time Sheet calculations
 

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


--
dkostel
------------------------------------------------------------------------
dkostel's Profile: http://www.excelforum.com/member.php...o&userid=16794
View this thread: http://www.excelforum.com/showthread...hreadid=319903

Take a look he

http://cpearson.com/excel/datetime.htm#AddingTimes

In article ,
dkostel wrote:

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).

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




"dkostel" wrote in message
...

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


--
dkostel
------------------------------------------------------------------------
dkostel's Profile:
http://www.excelforum.com/member.php...o&userid=16794
View this thread: http://www.excelforum.com/showthread...hreadid=319903