Results 1 to 3 of 3

Splitting days into full days,hours and minutes

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2018
    Location
    Netherlands
    MS-Off Ver
    M365 Subscription
    Posts
    23

    Splitting days into full days,hours and minutes

    Hi all,

    For an online game I'm cretaing an excell sheet which calculates the amount of speedup times we have left.
    As to be seen i the example sheet I have calculated the amount of days, hours and minutes.

    Only issue is that it all shows the same amount.

    What I would like to have is:

    the days row shows the full days
    the hours show the remaining full hours
    the minutes shows the minutes left

    So for example 1.34 days or 1930 minutes should show:

    1 day
    8 hours
    10 minutes

    Is this possible with formula's?

    Thanks for the tips and info
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates
    By hecgroups in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2019, 12:09 AM
  2. [SOLVED] Convert number to Days/hours/Minutes after 31 days
    By MB77035 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-05-2015, 11:45 AM
  3. [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
  4. Replies: 4
    Last Post: 08-03-2013, 05:10 AM
  5. Convert days -> Years, Months, Days, Hours, Minutes, Seconds
    By brharrii in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2012, 06:44 PM
  6. 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
  7. 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