Time to decimal
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Time to decimal

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    St Leonard, New Brunswick, Canada
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I've got a cell that shows me the time spent on a certAIN MACHINE (02:25:12), which shows hours:minutes:seconds

    How do I set this cell, without using a macro, to show me a decimal value (2.42 hours). I've tried all the cell formats on Excel.

    Don L.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,336
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    with time in A2,

    =A2*24

    Format the result as number

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-17 08:21, imonline wrote:
    I've got a cell that shows me the time spent on a certAIN MACHINE (02:25:12), which shows hours:minutes:seconds

    How do I set this cell, without using a macro, to show me a decimal value (2.42 hours). I've tried all the cell formats on Excel.

    Don L.
    Don, this can't be done with formatting. You could enter a formula in another cell that converts your time value (in cell A1) to hours...

    =A1*24

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    St Leonard, New Brunswick, Canada
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks!!! Dave and Mark


    The formula worked great, i know it seemed simple but I was racking my brain to find out how.

    Again thanks,

    Don L.

User Tag List

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