Lewis Wrote:
I'm working on a Time Calculator for work. On the time cards we have
two
sets of In and Out on each card. If as an example someone has clocked
in at
6:00 and Clocked out at 14:00. That person has worked their 8 hours and
as
they start to leave a truck shows up and they decide to clock back in
to
unload the truck. (the company pays them 2:00 hours as show up time.
I
don't have a problem with people clocking in 2X and out 2X that is
fairly
easy ((B4-B3+(B4<B3)+(B6-B5+(B6<B5))))

How can I have the program calculate (B4-B3+(B4<B3)) AND IF B50 AND
B6<=0
ADD "2:00" BUT IF B50 AND B60 ADD (B6-B5+(B6<B5)) TO (B4-B3+(B4<B3))

--
Thank You, God Speed, and Semper Fidelis

Hi Lewis

Try this:

=IF(AND(B5="",B6=""),(B4-B3+(B4<B3)),IF(AND(B50,B6<=0),(B4-B3+(B4<B3)),IF(AND(B50,B60),(((B4-B3+(B4<B3)+(B6-B5+(B6<B5)+"02:00")))))))


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=484760