Results 1 to 3 of 3

Convert time cell into a decimal cell leaving values exact.

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2015
    Location
    USA, USA
    MS-Off Ver
    2007
    Posts
    2

    Question Convert time cell into a decimal cell leaving values exact.

    Here's my excel example

    Date
    1-Jan Thu
    In
    4:12 PM
    Out
    7:03 PM
    In
    7:20 PM
    Out
    12:03 AM
    Exceptions
    Regular
    7:51
    Lunch
    0:17
    Total
    7:34

    My solution I'm looking for is taking cell J4 "7:34" and making it show up as 7.34 in cell K4.

    or alternatively, since I'm working on a payroll time sheet. I would like for some way, formula or otherwise to give me an absolute accurate value of 7 hours and 34 minutes, rolling over every 60 minutes to the next hour, any additional time that's added on properly when the "Total" cells are summed up for the total hours worked.

    Right now what I'm getting is a percentage based on the overall hours for that period of time; using formula "=(J14-INT(J14))*24" in cell K4; which gives me 7.57 for the value in cell K4.

    The problem with this is when you're dealing with time and money, this method overcompensates by .31 hour/minutes, making the dollar value based on the "excel interpretation of calculating the percentage of minutes of an hour" time, inaccurate.

    The actual value of hours worked would be, for example, 84 hours and 46 minutes.

    The excel summed up time with the formula above, equals 84.77 and the value I want in another cell that totals all the hours up should equal exactly 84.46.

    Any ideas? thanks in advance.
    Last edited by jiayinggw2; 01-24-2015 at 08:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert time to decimal
    By ExpressTyping in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2013, 11:27 PM
  2. [SOLVED] convert decimal number to time : convert 1,59 (minutes, dec) to m
    By agenda9533 in forum Excel General
    Replies: 22
    Last Post: 09-15-2013, 10:43 AM
  3. Replies: 3
    Last Post: 09-18-2008, 07:25 AM
  4. [SOLVED] CONVERT HEXADECIMAL CELL TO DECIMAL NUMBER
    By JAY in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2005, 11:06 PM
  5. Show a time from one calculated cell as a decimal in another cell.
    By KathyS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2005, 09:06 PM

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