+ Reply to Thread
Results 1 to 7 of 7

Employee Timesheet; calculating +/- hours worked

  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

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Employee Timesheet; calculating +/- hours worked

    Take a look at this.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

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

    Re: Employee Timesheet; calculating +/- hours worked

    Thanks for the help. Really appreciate it. I have a two more questions.
    1. would it be possible to have the plus/minus columns in one?
    2. Column "I" is "comment". I want a 8.5 hour day to be automatically entered in columns B,C,D,E, F (8:00;12:00;12:30;17:00:8:30) when I put either "Ferien" or Frei" in the "I" Column.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Employee Timesheet; calculating +/- hours worked

    1. Excel gives errors with negative times, that is why I create 2 colomns
    2. You can't have formulas and values at the same time in the same cell

    sorry for this bad news

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

    Re: Employee Timesheet; calculating +/- hours worked

    Thanks for the quick response.

    1. I understand
    2. Is there a different way that I can do this? Say, by using a formula to represent "Ferien" of "Frei"?

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Employee Timesheet; calculating +/- hours worked

    Maybe this way:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Employee Timesheet; calculating +/- hours worked

    This formula in G4 filled down will give +/- values in decimal format when formatted as general.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I don't understand the language so the values in column H I can't help with.

    Format F37 as [h]:mm
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. 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