+ Reply to Thread
Results 1 to 2 of 2

Breakdown to Time

  1. #1
    Registered User
    Join Date
    10-12-2021
    Location
    PH
    MS-Off Ver
    16
    Posts
    1

    Breakdown to Time

    please help me with this one. kindly break it down to time (OL to RN, RN to ML, etc.)

    Tracking ID From Province To Province Pick-up Duration OL Duration OL to RN Duration RN Duration RN to ML Duration GB to OP Duration OP Duration Overall Duration (Days) Overall Duration (Hours) SLA Status
    HNINJA000214319 ILN ILN 26.2833333 48.3 5.166666667 1.183333333 6 127 Breach
    HNINJA000214319 ILN ILN 26.2833333 1.183333333 37.2 9.9 25.18333333 6 127 Breach
    HNINJA000214319 ILN ILN 17.8 39.81666667 5.166666667 0.683333334 5 119 Breach
    HNINJA000214319 ILN ILN 17.8 0.683333334 37.65 10.55 24.46666667 5 119 Breach
    HNINJA000214319 ILN ILN 0.25 22.26666667 5.166666667 0.95 5 100 Breach
    HNINJA000214319 ILN ILN 0.25 0.95 37.43333333 10.48333333 23.25 5 100 Breach


    thank you
    Last edited by shawwe; 10-12-2021 at 03:31 AM.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,200

    Re: Breakdown to Time

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    1
    HNINJA000214319 ILN ILN 26.2833333 48.3 5.166666667 1.183333333 6 127 Breach HNINJA000214319 ILN ILN 26.2833333 48.3 5.166666667 1.183333333 6 127 Breach
    2
    HNINJA000214319 ILN ILN 26.2833333 1.183333333 37.2 9.9 25.18333333 6 127 Breach HNINJA000214319 ILN ILN 26.2833333 1.183333333 37.2 9.9 25.18333333 6 127
    3
    HNINJA000214319 ILN ILN 17.8 39.81666667 5.166666667 0.683333334 5 119 Breach HNINJA000214319 ILN ILN 17.8 39.81666667 5.166666667 0.683333334 5 119 Breach
    4
    HNINJA000214319 ILN ILN 17.8 0.683333334 37.65 10.55 24.46666667 5 119 Breach HNINJA000214319 ILN ILN 17.8 0.683333334 37.65 10.55 24.46666667 5 119
    5
    HNINJA000214319 ILN ILN 0.25 22.26666667 5.166666667 0.95 5 100 Breach HNINJA000214319 ILN ILN 0.25 22.26666667 5.166666667 0.95 5 100 Breach
    6
    HNINJA000214319 ILN ILN 0.25 0.95 37.43333333 10.48333333 23.25 5 100 Breach HNINJA000214319 ILN ILN 0.25 0.95 37.43333333 10.48333333 23.25 5 100



    Formula in B1:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    drag it right into K and down as long as needed.
    I do not clearly see what do you want to display as time, to be honest.
    Last edited by KOKOSEK; 10-12-2021 at 03:40 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split breakdown time between shifts
    By krzysiekpirat in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-29-2021, 10:33 AM
  2. hours breakdown, Ordinary, O/time 1.5 and O/Time 2.0
    By stax290 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-25-2019, 08:55 PM
  3. [SOLVED] Breakdown of Date and Time stamp
    By EXCELBENCH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2018, 02:54 PM
  4. Breakdown and Computation of lab time
    By omer123456 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-30-2015, 02:16 PM
  5. Exception/time breakdown by date; formatting and presentation
    By horariatersenha in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-11-2014, 05:41 PM
  6. Hours Breakdown to Normal Time, T5 & DT
    By Rallie1982 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2012, 04:39 AM
  7. Time breakdown function in Excel
    By tonycm1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2007, 08:14 AM

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