Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Converting time to fractions

  1. #1
    New Member
    Join Date
    Feb 2007
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Converting time to fractions

    Is there a formula for converting hours & minutes to fractions.

    Eg.
    Converting 1h 15min (1:15) to 1.25

  2. #2
    Board Regular
    Join Date
    Jun 2007
    Location
    SEOUL. KOREA
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting time to fractions

    Cell [A1]s value is " 1:15 ",
    Cell [B1]s formula is [ =A1*24 ] , result is " 1.25 "
    How to use well the Excel
    I want know...
    ps. Sheet Formula to WEB DownLoad Sheet2Web can use

  3. #3
    New Member
    Join Date
    Feb 2007
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Re: Converting time to fractions

    Got it

    Thank you for your help

Some videos you may like

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
  •