Results 1 to 8 of 8

Excel If-Else formula to capture ''hour“ and ”min" across an excel row

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2021
    Location
    Mumbai
    MS-Off Ver
    MS Office Standard 2010
    Posts
    5

    Excel If-Else formula to capture ''hour“ and ”min" across an excel row

    I have a row of "h min" values (eg:2h 15min) across a row. I need to capture the 'hour' and 'min' separately for which I'm using "=LEFT(B2,(FIND(" ",B2,1)-1))" and "=MID(B2,FIND(" ",B2)+1,256)" in separate cells, using the space separator to identify them seperately.

    The problem is when there is only either one value, i.e. only hour or only minute (eg. "2h" or "20min") in which case I get an error. How should I re-code both my LEFT and MID formula with IF-ELSE to ensure it still captures the hour/minute where it's present and gives a blank where it's not present.

    Many thanks.
    Attached Files Attached Files
    Last edited by Mithun.Uchil; 01-14-2021 at 02:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel formula to capture invoice number
    By sunboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2020, 01:54 PM
  2. Capture Value from a Cell only once at a specific hour.
    By EEEHHH in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-23-2019, 01:55 PM
  3. Replies: 3
    Last Post: 04-11-2018, 07:13 AM
  4. Replies: 1
    Last Post: 04-10-2018, 11:40 AM
  5. [SOLVED] Require a formula to display "Preparation Time" if half hour slot is available
    By john dalton in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-10-2014, 04:43 AM
  6. [SOLVED] Combine "=IF" and "=HOUR" statement for cell formula
    By chriswhite1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2013, 02:42 PM
  7. Replies: 0
    Last Post: 09-27-2012, 02:25 PM

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