+ Reply to Thread
Results 1 to 3 of 3

Time log into Decimals

  1. #1
    Registered User
    Join Date
    08-03-2015
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    38

    Lightbulb Time log into Decimals

    Hello,

    I need help finding the right formula to change hours/minutes into a decimal. I have a time tracking sheet where I input start times and end times and in the right most column I have a simple formula that subtracts end time from start time to give me the number of hours/minutes total. For invoicing purposes, I need that total time to automatically convert to a decimal so that I can use it as a multiplier with our hourly rate.

    For example:

    If I start a project at 1:40 PM and end at 2:30 PM it took me 50 minutes The value of 50 min is not useful when I go to invoice the time spent on this project. In order to multiply the total time spend on this project by our hourly rate, which in this case say it is $160, I need to then calculate 50 minutes into a decimal by dividing by 60. For clarity, this is what I need the decimal value for: 50/60 = 0.83 so $160 * 0.83 = 132.80.

    How can I do this easily, without having multiple columns for time start and time end and then another for the formula. I need this to be quick and easy because we cannot customize every single time entered by doing special formulas for each specific time entered. Please help!!!!

    Thank you

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Time log into Decimals

    Row\Col
    A
    B
    C
    D
    1
    Rate
    2
    $ 160.00
    3
    Start
    Stop
    Amount
    4
    13:40
    14:30
    $ 133.33
    C4: =(B4-A4) * 24 * C$2
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Time log into Decimals

    Something like this...
    Please Login or Register  to view this content.
    Replace D1 with the cell your 50 is in.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

+ 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. [SOLVED] Date and time format decimals
    By junada0 in forum Excel General
    Replies: 5
    Last Post: 02-25-2015, 06:42 PM
  2. Convert decimals to time eg 240.98 to 4:59
    By Marq555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2015, 03:41 AM
  3. [SOLVED] Excel 2007 : how convert time in decimals to time format
    By pksreela in forum Excel General
    Replies: 8
    Last Post: 07-10-2012, 12:17 AM
  4. Converting time into decimals...different problem.
    By ctess in forum Excel General
    Replies: 5
    Last Post: 10-09-2007, 07:31 PM
  5. converting time to decimals
    By bob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-11-2006, 04:35 PM
  6. [SOLVED] Time In Decimals
    By Superslinky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-22-2005, 05:09 AM
  7. Time in decimals?
    By Superslinky in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2005, 02:09 PM

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