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.
Bookmarks