Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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:

=IF(24*(C2-B2) > 10, 10, 24*(C2-B2))

Then in Column E add a new formula:

=IF(D2=10, ABS(10.00 - (24*(C2-B2))),0)

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: Google Spreadsheet Hours Worked

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.