An example of the excel data:
The columns below are Code, Code Name, Start time, End Time, Modifier Name
33157437 edepp 2/12/02 9:13:00 AM 2/12/02 9:13:00 AM jpm
33124494 ICRTT 2/12/02 9:14:59 AM 2/12/02 9:17:39 AM dhs
33200437 oerd 2/12/02 9:17:28 AM 2/12/02 9:18:03 AM cer
33689382 oerd 2/12/02 9:22:21 AM 2/12/02 9:22:30 AM cr2
33879897 poerr 2/12/02 9:24:51 AM 2/12/02 9:35:26 AM dtd
34112763 ares 2/12/02 9:28:43 AM 2/12/02 9:28:44 AM cer
34127763 ibris 2/12/02 9:29:10 AM 2/12/02 9:29:10 AM mdb
34081197 porii 2/12/02 9:29:12 AM 2/12/02 9:29:12 AM ejt
34096229 oerd 2/12/02 9:29:16 AM 2/12/02 9:29:17 AM vee
34208197 smrs 2/12/02 9:30:35 AM 2/12/02 9:32:39 AM bkh
34386494 smrs 2/12/02 9:33:22 AM 2/12/02 9:33:38 AM bkh
34438162 smrs 2/12/02 9:34:15 AM 2/12/02 9:34:29 AM bkh
34480835 smrs 2/12/02 9:35:00 AM 2/12/02 9:35:10 AM bkh
34407264 icrii 2/12/02 9:35:02 AM 2/12/02 9:35:06 AM jdw
34539437 glej 2/12/02 9:35:43 AM 2/12/02 9:35:44 AM ajc
Does anyone here know how to convert those excel data into an appropriate data format which can be convert into time graph? For instance (not in a precise graph):
33157437 |--jpm-|
34096229 |---------------vee-----------------|
34539437 |-------------------------ajc------------------------|
1/1 2/1 3/1 4/1 ....
10:00 12:00 14:00 16:00 ....
Any information would be appreciate!
Bookmarks