+ Reply to Thread
Results 1 to 7 of 7

Convert Hours, Minues and Seconds To Time Decimal

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    53

    Convert Hours, Minues and Seconds To Time Decimal

    Hi,
    I was wondering how i can amend this function
    Please Login or Register  to view this content.
    to change the time format to decimal. It is even better if I can just retain this function but able to find the difference between the start and end date and get the duration in units of hours and also in units of minutes.

    There's a sample folder attachmed to this post. Thanks.
    Attached Files Attached Files

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

    Re: Convert Hours, Minues and Seconds To Time Decimal

    Not really clear what you want... are you by any chance saying:

    Q2: =24*(P2-O2)

    R2: =Q2*60

    (test first to see)

  3. #3
    Registered User
    Join Date
    07-08-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Convert Hours, Minues and Seconds To Time Decimal

    Sorry if i wasn't very clear with the ques. I want to change the format 'time difference' eg in column N2, 2(hrs)45(mins):10(seconds) into hours, 4 decimal place and into minutes, 2 decimal place. You can ignore columns O and P. But i will need to amend the function in the the new start time and new end time first to find the time difference in hours. Likewise, to find the difference in minutes.
    Last edited by Nett; 08-07-2009 at 04:52 AM.

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

    Re: Convert Hours, Minues and Seconds To Time Decimal

    Now I really don't understand... post a revised sample manually inserting your expected/desired output in N.

  5. #5
    Registered User
    Join Date
    08-07-2009
    Location
    Road less travelled by
    MS-Off Ver
    Excel 2007, Excel 2003
    Posts
    5

    Re: Convert Hours, Minues and Seconds To Time Decimal

    A more simpler approach would be:

    Q2: =N2*24
    R2: =Q2*60

    Then you can use the 'Format Cell' selection from the right-click cell menu. Choose 'Custom' from the categories of the Number Tab then type 0.000 in the text box for the 4 digit decimal and so on...
    Last edited by technoeunuch; 08-07-2009 at 06:02 AM.

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

    Re: Convert Hours, Minues and Seconds To Time Decimal

    technoecrunch, welcome to the board, however please note:

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

  7. #7
    Registered User
    Join Date
    08-07-2009
    Location
    Road less travelled by
    MS-Off Ver
    Excel 2007, Excel 2003
    Posts
    5

    Re: Convert Hours, Minues and Seconds To Time Decimal

    Oh sorry about that sir, will do. I'll be sure to not miss 'em next time. My apologies

+ 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