+ Reply to Thread
Results 1 to 2 of 2

Formula for overtime rate

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Manila
    MS-Off Ver
    Excel Mac 2011
    Posts
    8

    Lightbulb Formula for overtime rate

    * I need help on the "EDIT" part. I posted a thread about the first problem yesterday and saved it as SOLVED already. But I had another connecting problem, so I figured it'd be best to quote my previous situation to understand my current question better.

    Let's say for example I have a work overtime of 1 hour and 15 minutes (1:15). For each overtime hour, the rate is $66.56, and for each overtime minute, the rate is $1.10 (The price is bit high because I'm using the value for my country, not the dollar rate).

    In this case, the solution would be (# of hours x 66.56) + (# of minutes x 1.1) = overtime pay. Thus, (1 x 66.56) + (15 x 1.1) = 83.06 (the overtime pay that I would be receiving).

    Is it possible to encode a formula in excel in this way? That if I input the hours and minutes of overtime, the specific cell would automatically solve like this?

    I hope someone can help me! Thank you!
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    EDIT: (I need help on this part)

    If I am absent on a specific day, I obviously wouldn't have any overtime. How do I add the IF FUNCTION in the formula << =HOUR(A1)*66.56+MINUTE(A1)*1.1 >> ?

    If I just leave it blank, it would just show an error: #NUM!

    Thanks for your help!
    Last edited by mishxco; 06-06-2013 at 10:40 PM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    6,994

    Re: Formula for overtime rate

    Maybe
    =IF(A1=0,"",HOUR(A1)*66.56+MINUTE(A1)*1.1)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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