formula
I have done a excel work sheet to work out my wage but I am just stuck on one
thing. When I work longer than 8 hours I get an hours dinner brake unpaid.
Im know wanting to know if there is a formula that works it out. In Cell B2
I have the time I started and in C2 the time I finish. In cell D2 I have the
formula =SUM(C2)-(B2) that equals the total amount off hours I work. Well now
I want it to automatically take 1 off if the hours are 8 or over 8.
|