Time attendance calculation problem

[Tia]

Hello

I am trying to find a formula for the time attendance for the
employees wich include the following rule
A5=DATE
C5= IN
D5=OUT
E5=TOTAL HOURS
G=TOTAL+DEDUCTED HOURS
I NEED A FORMULA FOR THE G=???
G= THE FOLLOWING RULES
WEEKDAY = 5 DAYS PR WEEK (total hours minus 2 hours )
Saturday(NOT OVERTIME) if they worked it will be as a normal working
day (total hours minus 1 hour)
Sunday (NOT OVT ) if they worked it will be a normal working day
(count total hours without deduction)

So i need a formula to the G5
Help me please

 

[Bob Phillips]

You only have to post once, I answered in other post.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)