+ Reply to Thread
Results 1 to 4 of 4

Calculating overtime

  1. #1
    Registered User
    Join Date
    08-08-2005
    Posts
    8

    Calculating overtime

    I've already figured out how to enter employee's time, but now I want to have it return anything 40 hours and below into one cell and all hours over 40 into another. Any ideas?

  2. #2
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by jennerifw
    I've already figured out how to enter employee's time, but now I want to have it return anything 40 hours and below into one cell and all hours over 40 into another. Any ideas?
    A very simple approach could be this. In Cell C1 (for example), enter this formula,

    =if(B1<=40,B1,"")

    where Cell B1 contains the employee hours. This formula means that if the total employee hours in Cell B1 is equal to or less than 40, then it will appear in Cell C1. Otherwise, if this condition is not true, Cell C1 will just be blank.

    On Cell D1, enter this formula

    =if(B1>40,B1,"")


    again, where Cell B1 contains the employee hours. This formula means that if the condition (Employee hours > 40) is met, then Cell D1 will show the employee hours. And, if this condition is not met, Cell D1 will be empty.

    Hope this will help you.

    Regards.
    BenjieLop
    Houston, TX

  3. #3
    Peo Sjoblom
    Guest

    Re: Calculating overtime

    To get hours over 40 using time format

    =MAX(D1-"40:00",0)

    if you are using integers replace "40:00" with 40

    for 40 and lower

    =MIN(--"40:00",D1)

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "jennerifw" <[email protected]> wrote
    in message news:[email protected]...
    >
    > I've already figured out how to enter employee's time, but now I want to
    > have it return anything 40 hours and below into one cell and all hours
    > over 40 into another. Any ideas?
    >
    >
    > --
    > jennerifw
    > ------------------------------------------------------------------------
    > jennerifw's Profile:
    > http://www.excelforum.com/member.php...o&userid=26071
    > View this thread: http://www.excelforum.com/showthread...hreadid=394076
    >



  4. #4
    Registered User
    Join Date
    08-08-2005
    Posts
    8
    Peo-

    Your suggestion gave me exactly what I was looking for. Thanks for your help!

+ Reply to Thread

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