I have this function to calculate a weekly total hours for a person.
This is for a 7 day week schedule.
=MOD(C4-B4,1)+MOD(E4-D4,1)+MOD(G4-F4,1)+MOD(I4-H4,1)+MOD(K4-J4,1)+MOD(M4-L4,1)+MOD(O4-N4,1)
How can I substract 30 minutes for lunch per day that this person
works.. Keep in mind that this person will sometimes work 3 days of the
week and sometimes he/she will work 5 days of the week. The days of the
week will vary.
Thanks in Advance
--
jcc31
------------------------------------------------------------------------
jcc31's Profile:
http://www.excelforum.com/member.php...o&userid=24692
View this thread:
http://www.excelforum.com/showthread...hreadid=520653