+ Reply to Thread
Results 1 to 2 of 2

Converting a Decimal Value to a Time Value

  1. #1
    An Irish Airman
    Guest

    Converting decimals into time

    I have been able to convert time in the format "hh:mm" but what about a situation wherein I have to convert decimals like 130.62 into time/hours

  2. #2
    Forum Contributor
    Join Date
    12-07-2004
    Posts
    596

    Converting a Decimal Value to a Time Value

    Problem:
    Converting the decimal values in column A to correctly formatted time values.

    Solution:

    Divide each number by 24 as follows:
    =A2/24
    Format your result cells as custom \"[hh]:mm\".

+ 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