+ Reply to Thread
Results 1 to 2 of 2

Set scheduled break and once i enter it on cell, it will result if i am adhering or non ad

  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    Edmonton, AB
    MS-Off Ver
    Excel 2003
    Posts
    1

    Set scheduled break and once i enter it on cell, it will result if i am adhering or non ad

    hi, looking to get a formula for this:

    situation:
    i have 4 set of breaks: 1st break (10 minutes), lunch (1 hour), 2nd break ( 10 minutes) and personal break (10 minutes).

    i would like to have something where in if a i am the set scheduled break and once i enter it on cell, it will result if i am adhering or non adhering.

    example:

    scheduled breaks are:
    10:00 - 10:10
    1:00 - 2:00
    6:15 - 6:25

    actual breaks taken:
    10:00 - 10:00 result = adhering
    12:55 - 1:55 result = adhering (breaks taken 5 minutes before the scheduled breaks is adhering)
    6:30 - 6:40 = non adhering..

    color should appear as well : adhering is green; non adhering is red.

    really need help for this so bad..

    thank you.

  2. #2
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: Set scheduled break and once i enter it on cell, it will result if i am adhering or no

    Hello yammie
    Just to clarify the rules :

    1. break times
    10:00 - 10:10
    1:00 - 2:00
    6:15 - 6:25

    2. break can start up to 5 mins before the break times

    3. break durations
    lunch - 60 mins
    other - 10 mins

    4. times around personal break ??
    5. could personal break be paired with other breaks, eg. 50min lunch + 10 min personal break = adhere for lunch ?
    6. if breaks are shorter, do they adhere or not. Can one be shorter and another longer and overall they adhere ?

    Regards
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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