Results 1 to 18 of 18

Need help by Timesheet

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Nederland, Den Haag
    MS-Off Ver
    Excel 2016-2019 (nl-NL)
    Posts
    14

    Need help by Timesheet

    I have a timesheet created, with the examples that were in the forum.
    I've gotten a lot of help, but knowledge is invaluable. (sigh)
    I do not get out in the totals of hours.

    1st attachment is how I filled my hours.
    it's a bit clumsy, but for me it was eventually cluttered.
    zonder puntjes.xlsm

    2nd attachment is with the help of fellow forum users become more beautiful.
    But ....
    there are some points that can be better.
    Map3.xlsm

    In column O : normal hours 100 % there is 8 hours .
    but if I have to work 4 hours, 4 hours standing. (Mon - Fri)
    If I work more than 8 hours than the extra hours should be allocated.
    My Employer is flexible with working hours, if total working hours is 8.
    If there is little work, you finish work, clean up and go home. This is less than 8 hours of work.

    In a quarterly census will only work on a Saturday .
    Again, it is the more people count of the faster we go home .

    Column T and U is the total hours worked (= sum of column N)
    Box U4 : I have worked fewer hours , even if I have overtime one day .
    I have 38 hours worked including overtime pay everything as 38 hours .
    I have 40 hours worked including overtime pay everything as 40 hours .
    I have 48 hours worked including overtime pay over 40 hours and 8 hours for holiday savings . ( Leave)

    All times are entered as military format manually. 800 hours is 8:00.

    Please work step by step. that i understand the formule.
    keep the layout the same, if possible.

    many thx/ love,
    Mofasa

    Moderator's note: See also this thread posted in Dutch --6StringJazzer
    Last edited by 6StringJazzer; 02-06-2014 at 12:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. timesheet help please
    By texmd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 02:47 AM
  2. Timesheet
    By greg123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2012, 03:38 AM
  3. Timesheet Help
    By swoznia in forum Excel General
    Replies: 3
    Last Post: 05-25-2012, 02:51 PM
  4. TimeSheet
    By superwiki in forum Excel General
    Replies: 7
    Last Post: 05-27-2009, 12:22 PM
  5. [SOLVED] Timesheet
    By Matt in forum Excel General
    Replies: 3
    Last Post: 09-15-2005, 05:14 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