Results 1 to 4 of 4
  1. #1
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Converting time total to decimal (2002)

    Every month my staff insist I pay them, and those who are hourly paid, use a swipe system that gives me a report for each day's hours worked.
    This I import into Excel, do a sum of the month's hours, and end up with a total of hours and minutes.
    So far, so good.
    However, when it comes to entering their hours into the payroll system, I need to enter the hours worked in decimals, and having a formula that would convert the minutes in the total into a decimal figure would be very convenient.
    In the attached example, I want to display the decimal equivalent of 116:19 (the total of the column above and formatted [h]:mm) and show it as 116.32 in cell N21.
    Could some kind soul assist, please? - such manipulation of dates and times are beyond my ken.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Converting time total to decimal (2002)

    Use this formula in N21:
    =L21*24
    If Excel formats it as a time, use Format | Cells to change the format to a number format.

    Explanation: times are stored internally as a fraction of 1 day: 6 hours = 0.25, 12 hours = 0.5 etc. To obtain the actual number of hours, multiply with 24 (the number of hours in a day).

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting time total to decimal (2002)

    Perfect - thank you!

    So, that's about 17 pints of Guinness I owe you now, yes? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Converting time total to decimal (2002)

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •