Timesheet and calculating over 40 hours
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.
|