+ Reply to Thread
Results 1 to 3 of 3

Over time formula assistance needed

  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

  2. #2
    Forum Contributor
    Join Date
    07-24-2009
    Location
    Valrico, FL USA
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: Over time formula assistance needed

    Would it do what you want if you change the formula in cell H11
    From: =IF(G11="","",IF(G11<2,3,0))
    To: =IF(G11=0,0,IF(G11<2,3,0))
    then copy down?

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

    Re: Over time formula assistance needed

    Hey Thanks for the Help, it appears to work very well now.

    Thanks a bunch

+ 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. 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