# Calculating overtime hours on a timesheet

1. ## Calculating overtime hours on a timesheet

I thought I had everything worked out with this timesheet but I've discovered one more problem. Weekly Timesheet.xlsx The total overtime hours needs to show that anything over 40 hours in the Total Regular Hours cell is overtime. And it also needs to show only up to 40 hours in the Total Regular Hours cell. How do I fix this?

2. ## Re: Calculating overtime hours on a timesheet

Hi

Perhaps put some data in the time sheet and make a note on the sheet as I do understand what you mean! It seems to work OK.

3. ## Re: Calculating overtime hours on a timesheet

Weekly Timesheet.xlsx
Okay, I added what amounts to 49.50 hours. What I'd like to see happen is this... G18 should read no higher than 40 and H18 should include all overtime and read 9.50. Is there a way to do this?

4. ## Re: Calculating overtime hours on a timesheet

Your current formulae seem to work well for each day being restricted to 8 regular hours..

Alternatively, in G11 use
``Please Login or Register  to view this content.``
In H11 use
``Please Login or Register  to view this content.``
Copy down

In G18
``Please Login or Register  to view this content.``
in H18
``Please Login or Register  to view this content.``

5. ## Re: Calculating overtime hours on a timesheet

Hi tiffany04530

See the attached.

6. ## Re: Calculating overtime hours on a timesheet

Kevin.....not sure what you changed.

7. ## Re: Calculating overtime hours on a timesheet

Hi tiffany04530

I have changed the formulas in G11:GG17 & H11:H17. They are a bit long! But now Saturdays and Sundays go in the overtime column.

8. ## Re: Calculating overtime hours on a timesheet

That would be great if they always worked M-F but what about if there is an employee that had a regularly scheduled day on Saturday or Sunday?

9. ## Re: Calculating overtime hours on a timesheet

Hi

Then personally I think you need to redesign your spreadsheet then, because how does one know which days are regular time for each employee!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1