Timesheet and calculating over 40 hours

[brandon0409]

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.

[Pecoflyer]

Hi and welcome in A7 enter =MIN(40,A6) ( or instead of 40 refer to a cell containing the limit) in A8 enter =MAX(0,A6-40) (same remark)