Results 1 to 7 of 7

Employee Timesheet; calculating +/- hours worked

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2015
    Location
    Zurich
    MS-Off Ver
    2011
    Posts
    6

    Employee Timesheet; calculating +/- hours worked

    Hi!

    I'm trying to setup a basic Employee Timesheet on excel and I'm have an issue - I'm also not very proficient with excel. I'll attach my working Excel sheet to make thing clearer.

    What I want to do is to automatically calculate the +/- hours worked by an employee; Column G
    A full day would be 8.5 hours. So, if someone works 10.5 hours, then they have + 2 hours (2 hours overtime). Conversely, if someone only works 6.5 hours, then they have - 2 hours (2 hours minus/under-time).

    Each +/- would be calculated for the respective day.

    If there are any questions, then please let me know.

    Also if there is a better way to enter in work times, then I'd appreciate all inputs. Inputs in regards to other issues are also very welcome.

    Attached is my excel sheet.

    Best,
    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. Timesheet, hours worked with multiple varriables...
    By biozombie in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-22-2015, 09:00 PM
  2. Calculating time on employee timesheet
    By Tashia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-30-2014, 12:46 AM
  3. Calculating a timesheet for employee's
    By Sammy21 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-29-2012, 03:03 PM
  4. Replies: 0
    Last Post: 05-14-2012, 05:36 PM
  5. Calculating basic hours worked, between a time range and premium hours worked
    By RoyLittle0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-07-2012, 06:59 AM
  6. Replies: 0
    Last Post: 01-05-2012, 06:23 AM
  7. Calculating total overtime hours worked per employee
    By markjmcl in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 06:49 PM

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