Time Card Show Up Time
 

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

Time Card Show Up Time
 

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

Time Card Show Up Time
 

Mr. Sheppard,
Thank you for the input. I modified your line to read the following and it
worked. Here is what I had to enter but it will return an error if the
person were to clock back in at 0. This is much better than what I had.

=IF(AND(B5="",B6=""),(B4-B3+(B4<B3)),IF(AND(B50,B60),((B4-B3+(B4<B3))+(B6-B5+(B6<B5))),IF(AND(B50,B6=""),(((B4-B3+(B4<B3)+"02:00"))))))
--
Thank You, God Speed, and Semper Fidelis
Respectfully, Lewis


"Paul Sheppard" wrote:


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