Results 1 to 3 of 3

Thread: converting hours higher than 24 to decimal numbers

  1. #1

    converting hours higher than 24 to decimal numbers



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi,

    Here is a table I made, where I tried to convert hours to decimal numbers.
    As long as I stayed under 24 hours it worked fine,
    but when I reached the higher numbers it seems to have divided the number in 24 and show only the remainder....

    Here's what I wrote:
    hours decimal
    01:30 1.5 The formula I used is: =hour(A2)+minute(A2)/60
    13:15 13.25 The same formula is used on all rows.
    25:30 1.5 Why does it show 1.5 and not 25.5? How can I fix this?

  2. #2
    Excel is converting 25:30 to 1:30 that is why you are getting 1.5

    Try this and see if it works. Format the Cell(s) as general where you will put the formula.

    =INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2)

  3. #3

    Thank you!

    it worked, thank you!
    and sorry for the (very) late response....


    Quote Originally Posted by tommyt61 View Post
    Excel is converting 25:30 to 1:30 that is why you are getting 1.5

    Try this and see if it works. Format the Cell(s) as general where you will put the formula.

    =INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2)

Posting Permissions

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