+ Reply to Thread
Results 1 to 3 of 3

greater equal less than

  1. #1
    Registered User
    Join Date
    06-06-2010
    Location
    manchester uk
    MS-Off Ver
    Excel 2003
    Posts
    7

    greater equal less than

    hi there i am trying to build a calculator for the UK working time directive it requires workers to work no more than 48 hrs a week averaged over a 17 week period as drivers hours vary from day-day week - week i have made a weekly time sheet style spreadsheet which is fine until i get to

    if one week they work 56 hrs = 8 hrs above 48 hrs
    next week 48 hrs so that is equal to the weekly
    3rd week 42 hrs so they have worked less than 48 hrs
    etc etc

    what kind of formula would be best to work out if above below or equal to the 48 hrs

    i'm ok with basic formulas but this has me stumped
    thaks in advance if anyone can help

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: greater equal less than

    Hi,
    how do you define a week?
    Mo to Fr, inclusive week ends? How do you take holidays into consideration?

  3. #3
    Registered User
    Join Date
    06-06-2010
    Location
    manchester uk
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: greater equal less than

    the week starts sun finishes sat if a day is not used for any reason hol sick etc the value is counted as 00:00 as i have done the hrs as a time formula i know it would be easy if the hrs were less or equal to 48 hrs as it would be a simple subtraction it is if it is greater than 48hrs that i'm struggling on
    Last edited by ianm34; 06-07-2010 at 07:01 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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