+ Reply to Thread
Results 1 to 2 of 2

Timesheet to calculate hours, subtract lunch, and calculate overtime hours

  1. #1
    Registered User
    Join Date
    07-29-2021
    Location
    Pennsylvania
    MS-Off Ver
    O365
    Posts
    2

    Question Timesheet to calculate hours, subtract lunch, and calculate overtime hours

    Good afternoon! This is my first post.

    I am looking for a timesheet template that allows me to enter start/end times for employees and then calculate hours worked. From that, I want to subtract a "lunch" - usually 30min - to determine hours worked. From that, I need to determine how many of those hours worked are standard and how many are overtime.

    I started the attached but F2 gave me an error trying to subtract the 8 regular hours from the 12 hours to determine the overtime hours (which would go in cell G2). E2 should be 11.5...but I can't get that to work.

    I know this is so elementary but I would appreciate the help.
    Attached Files Attached Files
    Last edited by TeamGoLong; 07-29-2021 at 12:41 PM. Reason: my mistake!

  2. #2
    Forum Contributor
    Join Date
    11-05-2019
    Location
    Tiki Island, TX
    MS-Off Ver
    Office 365
    Posts
    168

    Re: Timesheet to calculate hours, subtract lunch, and calculate overtime hours

    When doing math with time sometimes Excel can handle it automatically and sometimes you have to use the TIME function to help it out. See the attached spreadsheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to calculate hours worked w/lunch or w/o + OT column only total after 40 hours
    By blinhart in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2023, 11:14 AM
  2. Timesheet formula to subtract 1/2 a hour lunch only if 6 hours are worked
    By MrsBoot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2020, 01:55 PM
  3. Formula to calculate regular hours and overtime hours
    By judojames in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 05:30 PM
  4. Replies: 2
    Last Post: 01-17-2014, 02:22 PM
  5. Timesheet to calculate overtime hours
    By steve@stanley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2013, 12:27 PM
  6. Replies: 8
    Last Post: 06-11-2013, 05:34 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