+ Reply to Thread
Results 1 to 4 of 4

Timesheet help please

  1. #1
    Registered User
    Join Date
    11-13-2017
    Location
    London
    MS-Off Ver
    2017
    Posts
    1

    Timesheet help please

    Hi Guys (and Girls)
    Please can anyone help I have tried several you tube vids and I getting bits and pieces but still not grasping it
    Im a bus driver who needs to know when the company is cheating me out of my valuable pennies
    May I thank anyone in advance for any help with this sheet as my formulas are not working.
    I have different rates of pay for Monday to Fri - / weekends - working rest days also have a few extra pennies for unsociable hours (anytime after 22:00 - 05:00)
    I have included the rates on the sheet.
    PLEASE any help would be much appreciated workbook attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Timesheet help please

    for the calculation, there is the 40 minutes break, where to subtract ?
    some times easy, but if you start at 21:00 u ??


    kind regards
    Leo

  3. #3
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Timesheet help please

    Hi!

    There may be a simpler way to do this, but I found this model I had created earlier for a similar case, so I decided to give it a try.
    I use two helper tabs, one to list all dates & hours worked and another to exhibit hours values only, which I use in countif formulas for the unsocial hours.
    I eliminated the break columns and used them to list overtime and unsocial hours.
    If your regular hours are not 8, please change it in the header green cells.

    Then I use nested if formulas to contemplate the various pay rates.

    Put it to test and let's see if it works.

    Godspeed!
    Attached Files Attached Files

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Timesheet help please

    .
    Did you get the answer you were seeking ?

+ 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] Help on my timesheet
    By jrobin3360 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2017, 09:21 PM
  2. Timesheet
    By prchrj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2014, 06:37 PM
  3. Need help by Timesheet
    By MoFaSa in forum Excel - New Users/Basics
    Replies: 17
    Last Post: 02-19-2014, 07:06 PM
  4. Timesheet Help
    By swoznia in forum Excel General
    Replies: 3
    Last Post: 05-25-2012, 02:51 PM
  5. Excel 2008 : Timesheet sum help please !!
    By darkobird84 in forum Excel General
    Replies: 1
    Last Post: 01-11-2011, 10:48 AM
  6. TimeSheet-401
    By DenniSys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2010, 05:43 PM
  7. Timesheet
    By Martha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2008, 10:12 AM

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