Results 1 to 3 of 3

Over time formula assistance needed

Threaded View

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    Canada
    MS-Off Ver
    Office Professional Plus 2010
    Posts
    16

    Over time formula assistance needed

    Hi,
    I have attached a Time Sheet with formula's for calculating OT based on the time worked. If there is no time worked the subsequent number in the "worked" column (G) is zero, which then should leave no OT balances, they should be zero as well. Can anyone help with changing the formula so a zero balance in the "worked" column (G) will equal a zero balance in the "STO" column (H) as well? This should apply to all other over time columns (I, J) as well, they should remain at zero when there are no hours worked.

    I would appreciate any help on this. I also appreciate the previous help.

    Thanks,
    Russ

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assistance Needed with Indirect Formula Looking Up Images
    By taskmaster01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2014, 04:03 PM
  2. TRT = Total Run Time Assistance Needed please...
    By laurielee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2013, 07:13 PM
  3. [SOLVED] Logical Formula Assistance Needed
    By respuzy in forum Excel General
    Replies: 6
    Last Post: 03-24-2012, 09:44 AM
  4. Assistance needed to apply a formula
    By banny85 in forum Excel General
    Replies: 2
    Last Post: 06-23-2011, 06:33 AM
  5. Formula Assistance Needed
    By MoonShot in forum Excel General
    Replies: 4
    Last Post: 01-29-2010, 03:02 AM

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