+ 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
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    904

    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/MSO200;Win10/MSO2016
    Posts
    10,324

    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)

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