Closed Thread
Results 1 to 5 of 5

Time and Labor Calculation help Please...

  1. #1
    Registered User
    Join Date
    06-29-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Time and Labor Calculation help Please...

    Hi Friends

    I need help in couple of issues.

    A1 has Hourly Bill Rate: 72.00 - Formatted as number
    B1: has No of hours Billed: 32.25 ( 32 Hours 25 mins) - Formatted as number
    C1: Total Cost: A1*B1 - Formatted as number

    Here is the problem:
    C1 (A1*B1) = 2322.00 (72*32.25)

    But it is supposed to be 2334.00

    Explanation: 72*32 hours = 2304 & if we divide 72/60 then 1.2 per minute. so 25min * 1.2 = 30 - - -final cost: 2304+30=2334.00


    help me formula for excel formaula as well as Userform form formula.

    tekkie4@yahoo.com
    excel 2007
    Last edited by tekkie4; 01-02-2013 at 02:59 PM.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Time and Labor Calculation help Please...

    Hi

    Have you got your 32hours 25mins as a number or formatted as time in the [h]:mm format.

    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    06-29-2011
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Time and Labor Calculation help Please...

    formated as number

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,249

    Re: Time and Labor Calculation help Please...

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,249

    Re: Time and Labor Calculation help Please...

    this is your final warning! if i see you posting the same thread again i WILL ban you!!

Closed 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