Results 1 to 9 of 9

Downtime Analysis

Threaded View

Edd Win Downtime Analysis 03-11-2013, 07:11 PM
etaf Re: Downtime Analysis 03-12-2013, 07:19 AM
Edd Win Re: Downtime Analysis 03-12-2013, 01:48 PM
Edd Win Re: Downtime Analysis 03-12-2013, 01:48 PM
etaf Re: Downtime Analysis 03-12-2013, 01:54 PM
Edd Win Re: Downtime Analysis 03-12-2013, 06:10 PM
Edd Win Re: Downtime Analysis 03-13-2013, 06:20 PM
etaf Re: Downtime Analysis 03-13-2013, 06:22 PM
Edd Win Re: Downtime Analysis 03-15-2013, 02:59 PM
  1. #1
    Registered User
    Join Date
    03-10-2013
    Location
    dungannon
    MS-Off Ver
    Excel 2010
    Posts
    6

    Downtime Analysis

    Hi everyone, I am looking forward to solve this problem:
    Example:
    Downtime Explanation.jpg
    Better quality: http://postimage.org/image/krj3hfqgn/full/

    COL 1 is the Input data from Input worksheet, now..if in COL 1 between the times is 3 or more minutes gap, it is known as downtime. I want excel to recognize downtime after 3 or more minutes gap between two different times in (COL 1), and export or (mirror) those two different times in to COL 2, so that i can see without me lookin into COL 1.
    Than show the acctual gap time for each downtime in the COL 3 as shown in the example on the left.

    The whole point is,COL 1 is going to be an input, and the rest is going to be automatic, without me looking into the COL 1 myselfe, and picking out two different times with 3 or more minutes gap, and importing them into COL 2.

    What formulas,functions i have to create, examples would be nice Thank you!
    Last edited by Edd Win; 03-11-2013 at 07:31 PM.

Thread Information

Users Browsing this Thread

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

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