Results 1 to 4 of 4

Convert shorthand time text strings into full sentences

Threaded View

  1. 10-16-2018, 09:09 AM #1
    amit2385
    amit2385 is offline
    Registered User
    Join Date
    10-13-2015
    Location
    mumbai
    MS-Off Ver
    MS Office 2007
    Posts
    2

    Convert shorthand time text strings into full sentences

    Hello All,

    I want to convert below values in following format "xx days xx hours xx minutes"

    -2d 10h
    -27min
    -2h 29m
    -1w 1d
    -1w 1d
    -2d 12h
    -2d 8h
    -1d 18h
    0min
    0min
    1min
    -1w 2d
    -3h 59m

    Can anyone please provide me the formula.
    Last edited by AliGW; 10-16-2018 at 09:11 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a formula to compare two values in excel and provide the output in a different colunm
    By sghose in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2018, 04:41 AM
  2. [SOLVED] Can someone please help adding arguments to a formula or provide a better solution?
    By mshaneweaver in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-07-2014, 05:51 PM
  3. Apply an excel formula to provide sum of desired months
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2013, 10:22 AM
  4. Needed urgent help from a excel master to provide and explain a formula
    By amitav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2012, 04:21 AM
  5. [SOLVED] Provide formula for autofilter
    By Solomon14all in forum Excel General
    Replies: 2
    Last Post: 09-26-2012, 07:27 AM
  6. [SOLVED] provide:Need formula help
    By Paul in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-04-2006, 07:45 PM
  7. To return value that provide data to a formula
    By flaminang in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-29-2005, 05:54 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1