Results 1 to 4 of 4

Convert Time to Numeric Value

This is a discussion on Convert Time to Numeric Value within the Excel Questions forums, part of the Question Forums category; How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. ...

  1. #1
    New Member
    Join Date
    Jan 2003
    Posts
    3

    Default

    How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    65,181

    Default

    On 2003-01-23 12:26, smithsd wrote:
    How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?
    A true time entry like 11:30 is a 'numeric' value.

    If a time entry has text as underlying format, then...

    =TIMEVALUE(A1)

    would convert it to true time value.

  3. #3
    MrExcel MVP phantom1975's Avatar
    Join Date
    Jun 2002
    Location
    Omaha, Nebraska
    Posts
    3,962

    Default

    WELCOME TO THE BOARD!

    Have you tried entering your time in a cell and then formatting the cell to a number? When doing so, 10:33AM turns into .44444444.
    Silly Billy was here....

    ***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654

    Default

    On 2003-01-23 12:26, smithsd wrote:
    How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?
    Excel's time values are stored as fractions of a day. If you need to convert a time such as 11:24 AM into hours, minutes or seconds merely multiply by 24, 1440 or 86400 respectively, and then format the results using a desired number format to get 11.4 hours, 684 minutes or 41,040 seconds.

    [ This Message was edited by: Mark W. on 2003-01-23 12:47 ]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com