Results 1 to 10 of 10

Timesheet not calculating properly. Looking for help!

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2023
    Location
    USA
    MS-Off Ver
    Google Sheets
    Posts
    4

    Angry Timesheet not calculating properly. Looking for help!

    Hi everyone!

    I have been working on this timesheet document for a while now and cannot seem to get the right formula for my goal.

    Very simply, the document has a row for each day of the week. For each day, the fake employee fills out when they began and ended their shift and if they took any breaks. Column G is to add up all the hours between when they started and ended, while Column H then subtracts any break time they had.

    H11 is then used to calculate their weekly hours. This is where I run into my issue. I'd love for H11 to carry down to B12, but B12 be capped at 40 hours. Any time an employee goes over 40 hours, we obviously owe them OT. So in this example, the employee worked 46 hours, and 40 of them go into B12, but I can't seem to get the remaining six hours to be dropped into B13. I'm not sure if this is a time vs decimal point issue. I'd love for the G and H columns to be decimal points (5.5 hours vs 5:30 hours) but I couldn't get it to calculate properly with decimal points either.

    I've gotten it to the point where only B13 is my problem cell. Anyone able to help get me across the finish line?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet Calculating In and Out under date only
    By EXCELBENCH in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2018, 04:27 PM
  2. Need help with an hour calculating timesheet... please!
    By tag_addict in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-05-2015, 03:35 PM
  3. [SOLVED] Timesheet calculating differently
    By beitzy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-26-2013, 04:18 PM
  4. [SOLVED] Timesheet - calculating overtime
    By stupidname in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2012, 08:42 AM
  5. Need help calculating timesheet
    By Squiffer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-20-2012, 03:50 PM
  6. Calculating times on a timesheet?
    By pink pig in forum Excel General
    Replies: 3
    Last Post: 08-05-2008, 05:01 AM
  7. [SOLVED] Timesheet- Calculating
    By Craig in forum Excel General
    Replies: 4
    Last Post: 01-17-2006, 01:20 PM

Tags for this Thread

Bookmarks

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