+ Reply to Thread
Results 1 to 1 of 1

Timesheet Differential Trauma..

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver
    Excel 2003

    Timesheet Differential Trauma..


    This is my first post in this forum and I've got myself doozy of a problem

    I'm busy recreating our overtime claim form and had some success with the calculation of breaks from overall time.
    The problem i'm now facing is how to calculate hours on adjusted rate..
    I have an idea what to with Min/max to determine a time, I hit a brick wall when a shift starts in normal time, crosses all of ajusted rate, and ends in normal time again.

    Attached is a copy of the test sheet - I have tried a few approaches as some of the red values show, and some of the test values I randomly have on the right-hand side outside of the sheet.

    The conditions are:

    Automatically deduct 30 minutes for every 6hrs+ worked (mandatory break) per time in/out. (working)
    Show total hours worked below each day (working)
    Calculate adjusted rate for hours worked between 8pm-6am (NOT WORKING)

    Same conditions apply for weekend work


    I wouldn't be asking is I hadn't searched google and numerous excel-related sites for an obvious solution. A lot of the formulas used have been based on answers found elsewehere but i have reached an impasse with my current knowledge,
    Where possible, I'd like to avoid using VBA,
    It really is driving me to distraction, so any help or pointers in the right direction would be appreciated.
    Attached Files Attached Files
    Last edited by [DarkGUNMAN]; 11-16-2011 at 09:20 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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