+ Reply to Thread
Results 1 to 2 of 2

INO Formula assistance for simple Choice Time Accruals

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    NORTHEAST USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    INO Formula assistance for simple Choice Time Accruals

    New member In Need Of asssitance with a formula for simple accruals of Choice Time.

    Full/Time Employees (40 hours) accrue 8.9230 hours per bi-weekly pay (232 hours per calender year). I do not need a formula for recalculating when time is taken, only the accrual levels earned with each of the 26 pay periods. I know I can achieve this by simple addition but I need to create a chart for the entire organization...

    I feel confident that I can adjust the formula respectively for the different levels of accruals if I have someplace to start. We have 4 earning tiers, 4 employee tiers, and 24 different accrual rates.

    I am looking for a springboard. Any assistance will be greatly appreciated!

    Thanking you kindly in advance,
    Erin
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: INO Formula assistance for simple Choice Time Accruals

    Hello and welcome.
    Put that into excel, stay your desired outcome.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Time Stamps depending on choice in Drop Down List Choice
    By insayah in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2022, 09:53 AM
  2. Replies: 16
    Last Post: 11-21-2012, 09:47 AM
  3. Time Accruals!
    By adkmom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2012, 02:39 PM
  4. Excel 2007 : Vacation Accruals:first time posting
    By maine32 in forum Excel General
    Replies: 0
    Last Post: 07-23-2010, 12:00 PM
  5. Assistance with Time Keeping Formula
    By Barefoot Mark in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2006, 02:15 PM

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