+ Reply to Thread
Results 1 to 4 of 4

Job Execution times

  1. #1
    Registered User
    Join Date
    02-21-2018
    Location
    California
    MS-Off Ver
    MS office 2013
    Posts
    2

    Lightbulb Job Execution times

    Job,Day,Start time,End Time
    A,Mon,9:54:12,10:50:12
    B,Sun,5:54:12,7:54:12
    C,Tues,19:54:12,19:57:12
    D,Wed,11:54:12,12:56:12
    B,Thu,23:54:12,23:55:12
    A,Fri,9:54:12,9:57:12
    B,Sat,2:50:12,3:54:12
    E,Wed,9:54:12,10:54:12
    F,Thu,6:34:12,7:54:12
    G,Fri,9:54:12,9:54:13


    Which graph is suitable to show a clear picture on the jobs and its execution. Want to know when our machine is relatively free ?

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Job Execution times

    I don't know, maybe this bar chart...???

    This could be considered an open ended question as it's hard for us to interpret what you expect to see.
    Attached Files Attached Files
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    02-21-2018
    Location
    California
    MS-Off Ver
    MS office 2013
    Posts
    2

    Re: Job Execution times

    this is to find out what part of the day is relatively job free ?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Job Execution times

    Please tell us what you expect to see and then maybe we can work towards that goal.

    How would you like for the graph to look? Remember, this data doesn't mean anything to us or how it should be interpreted.

+ 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] Averaging the earliest start times and latest end times for multiple days
    By kbiro in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-26-2016, 02:15 PM
  2. Replies: 21
    Last Post: 05-11-2015, 03:53 PM
  3. Replies: 7
    Last Post: 04-09-2014, 09:25 AM
  4. calculating inter arrival times and statistical distribution of these times
    By ditmar.rijk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2014, 03:18 AM
  5. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  6. Replies: 0
    Last Post: 11-14-2011, 05:40 PM
  7. Macro Loop – Find Specific Times, Extract Date, Average Values of Times
    By ExcelQuestFL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-25-2010, 02:50 PM

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