+ Reply to Thread
Results 1 to 4 of 4

Difficulties with counting overtime, double IF's

  1. #1
    Registered User
    Join Date
    03-08-2007
    Posts
    5

    Difficulties with counting overtime, double IF's

    Hi everyone

    I trying to figure out how to make a calculation of overtime, but here's where it gets tricky:

    Normally weekly workhours = 37
    But in this case, because of an availability clause in the contract, overtime is not counted unless the weekly number of hours exceed 45.

    Therefore: I need a calculation of overtime based on these two facts.

    If weekly hours are below 37, then I need the hours 'owed' to the company needs to be displayed. At the same time, if the number of hours exceeding 37 is below 8, then nothing should be displayed, if the hours exceed 8 hours, then that number need to be displayed.

    I hope you can help.

    -Mako-

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Simply based on your facts (and not any laws), this should work for you:

    =IF(A1<37,37-A1&" owed",IF(A1>45,A1-45&" OT",""))

    HTH

    Jason

  3. #3
    Registered User
    Join Date
    03-08-2007
    Posts
    5
    Cheers Jason,

    It works like a charm. (According to Danish law, it's fine btw)

    -Mako-

  4. #4
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Good to hear.

+ 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