I'm keeping track of my hours from work on my own spreadsheet.



Scenerio:

1 Column (A1 - A5) Each cell containing a day's hours;
A1 = Monday
A2 = Tuesday
etc.

A6 = The week's total hours

What I want to do:

When I've reached 40 hours, anything over 40 will appear in an adjacent cell and calculate how many hours OVER 40 (My overtime) that I have accumulated.

I want it to do this automatically without me having to have multiple cells doing multiple other calculations. Or using some other nonsense jerry-rig.

Hopefully my explanation is clear.
thanks for any assistance.