+ Reply to Thread
Results 1 to 4 of 4

How to convert decimal value into total seconds

  1. #1
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    How to convert decimal value into total seconds

    I have a formula that reads like this

    =((11.4)-0.000000000946727*(11.4)*((5000)*5000))

    The formula is used to calculate a comparative run time at an elevation of 5000 feet. The time the run was in is 11 minutes and 40 seconds. What I need to do is convert the 11.40 into total seconds which would be 700.

    Now the actual 11.4 in the forumala is from a cell reference (say D14). It's whatever time the member plugs in (and so is the 5000, this represents the members altitude). I need the time to stay in a decimal format because I have a huge database that I perform a lookup on to find the point value for it for another calculation seperate from this one. If I were to plug 700 in place of 11.4 my calculated result would be 683.43 which is exactly what I need.

    Summary, how can I convert a decimal such as 11.4 to total seconds, in this case it would be 700? Any help would be appreciated!

    Thanks in advance!
    Last edited by purdue7997; 01-24-2010 at 11:40 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to convert decimal value into total seconds

    Few routes:

    Please Login or Register  to view this content.
    the latter requires activation of Analysis ToolPak Add-In in versions prior to XL2007

  3. #3
    Registered User
    Join Date
    09-08-2009
    Location
    Hawaii
    MS-Off Ver
    Excel 2013
    Posts
    68

    Re: How to convert decimal value into total seconds

    Quote Originally Posted by DonkeyOte View Post
    Few routes:

    Please Login or Register  to view this content.
    the latter requires activation of Analysis ToolPak Add-In in versions prior to XL2007
    Has anybody ever told you your a genius? Well you are and you saved me tons of time! Thank you very much!!!!

    I'll solve and post a rep!

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to convert decimal value into total seconds

    Thanks, however, If you lurk here as much as I do you'd find it's actually pretty difficult not to benefit from everyone else's expertise ... I would say that it is the board itself that is genius ... as individuals we all benefit from it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1