Results 1 to 18 of 18

Formula to find lowest time n 2 groups then the difference between them ignoring “-“

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    California
    MS-Off Ver
    2016
    Posts
    19

    Formula to find lowest time n 2 groups then the difference between them ignoring “-“

    So I need to have a formula look to F, G, H, I.

    look to see which is a lower time

    F or G

    then look to see which is a lower time in

    H or I

    then subtract the lower time from F/G from the lower time in H/I.

    it will also need to ignore any "-"- it encounters

    F g h i

    AMB Fire AMB12L Fire12L

    23:15:09 23:19:18 23:00:00 23:20:00
    23:19:18 23:15:09 23:20:00 23:00:00
    23:19:18 23:15:09 - 23:00:00
    23:19:18 23:15:09 23:20:00 -


    Any help would be greatly appreciated.
    Last edited by Medicguy; 09-28-2020 at 07:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Improved Formula / i've run out room to extend the current formula / (avdanced code needed
    By pmw19800 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2018, 06:19 AM
  2. date formula help needed with blank cell and monthly assumtions formula needed
    By Michael.Howarth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2018, 07:47 AM
  3. Replies: 3
    Last Post: 04-06-2016, 12:19 PM
  4. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  5. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  6. [SOLVED] index formula needed--how to get a formula to skip columns
    By rsmidtisu in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-02-2012, 11:22 AM
  7. Replies: 3
    Last Post: 09-07-2012, 12:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1