+ Reply to Thread
Results 1 to 3 of 3

calculating breaks

  1. #1
    bamboozled
    Guest

    calculating breaks

    What formula would I use to calculate breaks automaticaly, for example on an
    eight hour shift a one hour break should be deducted, in a six to eight hour
    shift half an hour should be deducted. Anything less than six hours and no
    break is deducted. I have set up a spread sheet to work out the hours worked
    but I need to take break off this, I would rather the spreadsheet calculate
    this for me, than me have to input the breaks manually.

  2. #2
    Ardus Petus
    Guest

    Re: calculating breaks

    Assuming your shift duration is in A2, calculated time is given by following
    formula:
    =IF(A2<"6:0",A2,IF(A2<"8:0",A2-"0:30",A2-"1;0"))

    Cheers
    --
    AP

    "bamboozled" <bamboozled@discussions.microsoft.com> a écrit dans le message
    de news: 6E062AE0-AC6C-46E0-9160-D48662244752@microsoft.com...
    > What formula would I use to calculate breaks automaticaly, for example on
    > an
    > eight hour shift a one hour break should be deducted, in a six to eight
    > hour
    > shift half an hour should be deducted. Anything less than six hours and no
    > break is deducted. I have set up a spread sheet to work out the hours
    > worked
    > but I need to take break off this, I would rather the spreadsheet
    > calculate
    > this for me, than me have to input the breaks manually.




  3. #3
    Ragdyer
    Guest

    Re: calculating breaks

    Since you say that you've already calculated hours worked (decimal number),
    then with that number in A1, try this:

    =(A1<6)*A1+(AND(A1>=6,A1<8)*(A1-0.5))+(A1>=8)*(A1-1)
    And copy down as needed.
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "bamboozled" <bamboozled@discussions.microsoft.com> wrote in message
    news:6E062AE0-AC6C-46E0-9160-D48662244752@microsoft.com...
    > What formula would I use to calculate breaks automaticaly, for example on

    an
    > eight hour shift a one hour break should be deducted, in a six to eight

    hour
    > shift half an hour should be deducted. Anything less than six hours and no
    > break is deducted. I have set up a spread sheet to work out the hours

    worked
    > but I need to take break off this, I would rather the spreadsheet

    calculate
    > this for me, than me have to input the breaks manually.



+ 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