+ Reply to Thread
Results 1 to 5 of 5

Time plots in Excel 2003

  1. #1
    Registered User
    Join Date
    10-22-2008
    Location
    Canada
    Posts
    3

    Time plots in Excel 2003

    Hi.
    I'm trying to plot the uptime for some equipment we use, on a day and time basis.
    The data I use looks like this:

    A B C
    Online 23:27:39 12-Oct-08
    Online 23:30:54 12-Oct-08
    Online 23:34:09 12-Oct-08
    Online 23:37:24 12-Oct-08
    Offline 23:40:37 12-Oct-08
    Offline 23:43:50 12-Oct-08
    Offline 23:47:03 12-Oct-08
    Offline 12:00:28 13-Oct-08
    Offline 12:03:41 13-Oct-08
    Offline 12:06:54 13-Oct-08
    Online 12:10:10 13-Oct-08
    Online 12:13:26 13-Oct-08
    Online 12:16:42 13-Oct-08
    Online 12:19:58 13-Oct-08
    Offline 12:23:11 13-Oct-08
    Offline 12:26:24 13-Oct-08
    Offline 12:29:37 13-Oct-08
    Offline 14:51:13 13-Oct-08
    Offline 14:54:26 13-Oct-08

    What I need to do is to extrach the 'Online" fields and plot the time as a bar in the graph, showing the windows over a 24 hour span; plot is by dau, for 30 days.
    Time would be on Y, and day/date on X.
    I have no idea how I can do it, so please help if you can.
    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    See if the attached is what you want.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-22-2008
    Location
    Canada
    Posts
    3
    Thanks Andy.
    It is close, but not exactly.
    What I actually need is to show uptime for a day, say 13 Oct as a single entry, but broken down as the machine was online for several periods of time over the day, e.g. 02:14:32-03:01:03, 11:12:34-14:23:20, 20:15:23-01:03:17 next day.
    Multiple entries in the same day. Maybe a scatter plot would work better than a bar graph.
    In your example, you have hidden the Offline records, haven't you?
    Would it be possible for the spreadsheet to extract only the Online records and calculate and plot the entry based on time on and time off for the particular set of data (over an Online set of recordings)?
    I am aware that this complicates the matter, but any solution that works will be good.
    Thanks,
    Leo

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481
    I will let Petr Bezucha finish helping you on this.

    Cross posting in the newsgroups is just as bad as posting on other forums without taking the time to let other know.

  5. #5
    Registered User
    Join Date
    10-22-2008
    Location
    Canada
    Posts
    3
    Andy,
    It's just too bad you took offense. I appreciate your help with the spreadsheet that works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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