View Single Post
 
Old 04-25-2014, 10:27 PM
brandon0409 brandon0409 is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Apr 2014
Posts: 1
brandon0409 is on a distinguished road
Default 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.
Reply With Quote