Sign up ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

1 Answer 1

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.