+ Reply to Thread
Results 1 to 4 of 4

Conversion of Days Hours Minutes elapsed into minutes

  1. #1
    Registered User
    Join Date
    11-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    2

    Conversion of Days Hours Minutes elapsed into minutes

    An Excel (Mac version) spreadsheet with a 'Allocated Time' Field in the format 0d 13h 2m needs to be converted to minutes. I would greatly appreciate any help.

    Thanks in advance.

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Conversion of Days Hours Minutes elapsed into minutes

    If you're happy to use formulae to do this, perhaps:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-15-2018
    Location
    London, England
    MS-Off Ver
    365
    Posts
    2

    Re: Conversion of Days Hours Minutes elapsed into minutes

    Thank you for getting back.

    It keeps coming up with an error. Not sure why. Help needed.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: Conversion of Days Hours Minutes elapsed into minutes

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. converting minutes to days, hours and minutes.
    By TheGrimm in forum Excel General
    Replies: 8
    Last Post: 11-23-2015, 02:23 AM
  2. convert days hours minutes seconds to just minutes
    By hollylynn in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 08:53 AM
  3. Convert Days:Hours:Minutes:seconds to minutes.
    By Kevingardner1 in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 06:44 PM
  4. [SOLVED] Elapsed Days Hours Minutes Excluding Weekends and Holidays
    By moshjosh in forum Excel General
    Replies: 7
    Last Post: 12-10-2012, 08:39 AM
  5. Excel 2007 : Elapsed Days, Hours, Minutes
    By janetk411 in forum Excel General
    Replies: 3
    Last Post: 12-07-2009, 11:06 AM
  6. [SOLVED] converting Days Hours & minutes into just minutes in excel
    By Six Sigma Blackbelt in forum Excel General
    Replies: 5
    Last Post: 04-28-2006, 04:45 PM
  7. Replies: 1
    Last Post: 04-08-2006, 10:45 PM

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