Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Thanked 0 Times in 0 Posts

    HMS time data conversion (2000)

    I have data in cells that are in the colon time format (12:28:00 AM) is what the cell reads. I want to cnvert these hh:mm:ss data to decimal hours. I can't find a function in Excell that will do that -- what is the easiest way to do this?

    =TIMEVALUE() does NOT work

    BTW, if I delete the "AM" from the rear of the cell 'text' then Excell just puts it back on there again...


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: HMS time data conversion (2000)

    Say A1 contains a time. In B1, enter the formula =24*A1, then set the number format for B1 to General, or to Number with 2 decimal places.

    Explanation: Excel internally stores times as fractions of 1 day. To convert to hours, multiply by 24 (the number of hours in one day).

    The AM is just the format, if you select A1 and select Format | Cells..., you can select another time format.

Posting Permissions

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