Hi
Try:
=IF(C2-B2=8,C2-B2-1,C2-B2)

HTH
Michael Mitchelson


"ste997" wrote:

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.