Results 1 to 5 of 5

Help with formula to auto create break times

Threaded View

avidcat Help with formula to auto... 01-15-2012, 02:54 PM
Richard Buttrey Re: Help with formula to auto... 01-15-2012, 03:18 PM
avidcat Re: Help with formula to auto... 01-15-2012, 04:01 PM
Richard Buttrey Re: Help with formula to auto... 01-15-2012, 04:38 PM
avidcat Re: Help with formula to auto... 01-15-2012, 05:08 PM
  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Help with formula to auto create break times

    This is a complicated formula, at least not something I can do.

    There is an draft attached to this email.

    Rules:
    First rule is that no breaks can overlap.
    1st Break is 40 Mins.
    2nd Break is 20 Mins.
    1st Break is at least 2 Hours After Time-In.
    2nd Break is at least 2 Hours Before from Time-Out.
    Each Employee might have a unavailable time for breaks.

    Not sure if it is possbile to create a formula like this, or I might need an Excel Wizard to do this.

    thanks for any help,

    Nick
    Attached Files Attached Files

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