Results 1 to 13 of 13

How to convert decimal into days, hours and minutes?

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2014
    Location
    Philippines
    MS-Off Ver
    MS Office 2010, 2013
    Posts
    5

    How to convert decimal into days, hours and minutes?

    Hi! Can you help me to convert these into days, hours, minutes...

    Example:

    46.65634971 should become 1 day 22 hours
    91.42876971 should become 3 days 19 hours
    74.02559486 should become 3 days 2 hours
    4.44146742849 should become 4 hours
    0.851588571344 should become 51 minutes
    Last edited by tony.; 11-24-2014 at 02:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert Days Hours and Minutes to decimal days
    By david1987 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2015, 05:44 PM
  2. [SOLVED] Convert Decimal Hours into Hours and Minutes in HH.mn format
    By Cortlyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2013, 03:48 PM
  3. [SOLVED] Convert Decimal hours and Minutes to minutes please.
    By Steved in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-05-2006, 12:35 AM
  4. [SOLVED] Convert days in decimal to days:hours:minutes
    By Todd F. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2006, 03:25 PM
  5. [SOLVED] Convert decimal days to Days,hours, minutes
    By Todd F. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 11:45 AM

Tags for this Thread

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