Results 1 to 5 of 5

Convert irregular text into hours

Threaded View

  1. #1
    Registered User
    Join Date
    09-09-2016
    Location
    Thailand
    MS-Off Ver
    2015
    Posts
    4

    Convert irregular text into hours

    Hi experts

    I've got the following data output to work with.

    ---------------------

    30 days 12 hours 18 minutes
    1 day 1 hour 1 minute
    45 minutes
    6 hours 1 minute

    ---------------------

    My goal is to convert this data into decimal hours.

    As you can see, the data is irregular, sometimes there's only 1 number (i.e. NOT 06 hours).
    Also the letters have different lenghth (day, days etc.)

    I've tried to split the data up into cells for further processing but I'm getting the following problem

    30
    1
    45
    6

    If there are no days, the hours jump into collum A and if there are no days and hours, the minutes jump in collum A.

    I've tried to read out the cell with

    =LEFT([@[*Time in Online Sessions]];2)*24

    That works well, but how to handle the middle and the right part, if the length of numbers and text are varying?



    Sorry for my bad english and thanks fpr your help.
    Last edited by thairicci; 09-10-2016 at 01:57 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 text time into hours
    By Justmegan93 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-11-2016, 10:06 AM
  2. [SOLVED] Function or macro to convert string with weeks, days, hours, minutes to Hours
    By kknb0800 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 11:35 AM
  3. Convert text to hours/timestamp
    By Daniel86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-12-2012, 06:06 PM
  4. Irregular hours
    By Fedde in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2007, 07:34 PM
  5. calculating irregular hours
    By Fedde in forum Excel General
    Replies: 1
    Last Post: 01-05-2007, 04:12 AM
  6. Replies: 5
    Last Post: 06-22-2006, 10:10 PM
  7. Convert irregular data to monthly equivalent?
    By RBW in forum Excel General
    Replies: 3
    Last Post: 04-02-2006, 03:40 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