Let's assume you have four times (IN/Out-lunch/IN/Out) in columns C, D,
E and F, and your rate is $12.50/hour your formula would look like
this:
=(((D2-C2)+(F2-E2))*24)*12.5
for a simple IN/OUT it would be:
=((D2-C2)*24)*12.5
Does this work for you?
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=486045