so i'm using Google docs to keep track of time. I'm using the bimonthly timesheet template, what would be useful is if the spreadsheet coulld start adding hours to another column when the total hours worked per day exceeds 10 hours. What would be the best way to do this?
You can do this by modifying the current formulas and adding one of your own.
Based on the template you mentioned, you need to amend the formula for the Total hours per day: column to:
Then in Column E add a new formula:
Then the Formula for Total Hours For This Pay Period needs to be amended to include any hours over the 10 hour threshold.
This will give you an output similar to the this: