+ Reply to Thread
Results 1 to 4 of 4

hh:mm converted to decimal in same cell

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    Azle, TX.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cool hh:mm converted to decimal in same cell

    OK...here's my delimma. I'm creating a spreadsheet and I need to be able to enter hh:mm worked in a cell and have it converted, in the same cell, to a decimal so that it can be multiplied by payrate to give me a total for weekly labor. I've been able to find formulas that will convert HH:MM in A1 to decimal in A2... but I'm looking to simplify if at all possible. I know programs like quickbooks can do this.... I just need help making this a reality on my spreadsheet.

    Thanks in advance for you help and patience.

  2. #2
    Registered User
    Join Date
    04-20-2011
    Location
    Azle, TX.
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: hh:mm converted to decimal in same cell

    btw... I'm not sure which version I have. I'm at work...but it IS a new computer running windows 7 it looks like. Please forgive my computardation.

  3. #3
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: hh:mm converted to decimal in same cell

    You don't need to convert it in the cell. Just use 24 *hh:mm*payrate for the cost. Make sure the cost cell is formatted as number or currency.

  4. #4
    Forum Contributor Charlie_Howell's Avatar
    Join Date
    09-27-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: hh:mm converted to decimal in same cell

    do you pay Overtime? if so ,be mindful of the calculations.
    I've uploaded an example of time calculations
    If you want an example of overtime calculations just let me know.
    Attached Files Attached Files

+ 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