+ Reply to Thread
Results 1 to 2 of 2

Trying to figure out overtime or no overtime without a neggative #

  1. #1
    Registered User
    Join Date
    11-13-2013
    Location
    Grand Rapids,MI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Trying to figure out overtime or no overtime without a neggative #

    Im having a heck of a time with this if someone could help there would be many thanks..

    N15 is 50.5 I am trying to get E14 to show only the hours over 40 (which is not the problem) or when under 40 I need E14 to just be 0
    Thanks

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Trying to figure out overtime or no overtime without a neggative #

    =IF(n15>40,N15-40,0)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

+ 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. Calculating daily overtime and weekly overtime
    By Guy Montague in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-22-2016, 04:55 PM
  2. Overtime & Double Overtime - IF function
    By KimBVS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-14-2014, 04:46 AM
  3. Timesheet calculation for overtime and double overtime
    By eortega in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-29-2013, 03:28 PM
  4. Replies: 8
    Last Post: 06-11-2006, 05:34 AM
  5. how do I write a formula that will figure weekly overtime?
    By jasperPcuccumber in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 04-17-2005, 11:10 PM

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