Joneye
Well-known Member
- Joined
- May 28, 2010
- Messages
- 783
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Im looking for a tutorial / advice on how to plot a time, date and output graph;
X Axis Date
Y Axis Time
Y Axis Action (email, lunch)
Snap shot of my data below:
X Axis Date
Y Axis Time
Y Axis Action (email, lunch)
Snap shot of my data below:
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Date | Time | Action | 27 Emails Sent | Time Between Emails | ||
2 | 17-08-16 | 9:30 AM | Start | 0 | |||
3 | 17-08-16 | 9:57 AM | 1 | 0:27 | |||
4 | 17-08-16 | 10:20 AM | 1 | 0:23 | |||
5 | 17-08-16 | 10:39 AM | 1 | 0:19 | |||
6 | 17-08-16 | 10:50 AM | 1 | 0:11 | |||
7 | 17-08-16 | 10:57 AM | 1 | 0:07 | |||
8 | 17-08-16 | 11:19 AM | 1 | 0:22 | |||
9 | 17-08-16 | 11:38 AM | 1 | 0:19 | |||
10 | 17-08-16 | 12:11 PM | 1 | 0:33 | |||
11 | 17-08-16 | 12:15 PM | Lunch | 0 | 0:04 | ||
12 | 17-08-16 | 1:30 PM | Lunch | 0 | 1:15 | ||
13 | 17-08-16 | 2:30 PM | 1 | 1:00 | |||
14 | 17-08-16 | 2:58 PM | 1 | 0:28 | |||
15 | 17-08-16 | 3:06 PM | 1 | 0:08 | |||
16 | 17-08-16 | 3:28 PM | 1 | 0:22 | |||
17 | 17-08-16 | 3:51 PM | 1 | 0:23 | |||
18 | 17-08-16 | 4:17 PM | 1 | 0:26 | |||
19 | 17-08-16 | 4:28 PM | 1 | 0:11 | |||
20 | 17-08-16 | 4:39 PM | 1 | 0:11 | |||
21 | 17-08-16 | 4:55 PM | 1 | 0:16 | |||
22 | 17-08-16 | 5:20 PM | 1 | 0:25 | |||
23 | 17-08-16 | 5:26 PM | 1 | 0:06 | |||
24 | 17-08-16 | 5:32 PM | 1 | 0:06 | |||
25 | 17-08-16 | 5:41 PM | 1 | 0:09 | |||
26 | 17-08-16 | 5:47 PM | 1 | 0:06 | |||
27 | 17-08-16 | 6:03 PM | 1 | 0:16 | |||
28 | 17-08-16 | 6:13 PM | 1 | 0:10 | |||
29 | 17-08-16 | 6:18 PM | 1 | 0:05 | |||
30 | 17-08-16 | 6:25 PM | 1 | 0:07 | |||
31 | 17-08-16 | 6:38 PM | 1 | 0:13 | |||
32 | 22-08-16 | 9:30 AM | Start | 0 | |||
33 | 22-08-16 | 9:55 AM | 1 | 0:25 | |||
34 | 22-08-16 | 10:03 AM | 1 | 0:08 | |||
35 | 22-08-16 | 11:10 AM | 1 | 1:07 | |||
36 | 22-08-16 | 11:29 AM | 1 | 0:19 | |||
37 | 22-08-16 | 11:40 AM | 1 | 0:11 | |||
38 | 22-08-16 | 11:52 AM | 1 | 0:12 | |||
39 | 22-08-16 | 12:05 PM | 1 | 0:13 | |||
40 | 22-08-16 | 12:13 PM | 1 | 0:08 | |||
41 | 22-08-16 | 12:15 PM | Lunch | 0 | 0:02 | ||
42 | 22-08-16 | 1:45 PM | Lunch | 0 | 1:30 | ||
43 | 22-08-16 | 2:09 PM | 1 | 0:24 | |||
44 | 22-08-16 | 2:30 PM | 1 | 0:21 | |||
45 | 22-08-16 | 2:43 PM | 1 | 0:13 | |||
46 | 22-08-16 | 3:11 PM | 1 | 0:28 | |||
47 | 22-08-16 | 3:46 PM | 1 | 0:35 | |||
48 | 22-08-16 | 3:56 PM | 1 | 0:10 | |||
49 | 22-08-16 | 4:07 PM | 1 | 0:11 | |||
50 | 22-08-16 | 4:23 PM | 1 | 0:16 | |||
51 | 22-08-16 | 4:36 PM | 1 | 0:13 | |||
52 | 22-08-16 | 4:44 PM | 1 | 0:08 | |||
53 | 22-08-16 | 4:50 PM | 1 | 0:06 | |||
54 | 22-08-16 | 4:57 PM | 1 | 0:07 | |||
55 | 22-08-16 | 5:09 PM | 1 | 0:12 | |||
56 | 22-08-16 | 5:28 PM | 1 | 0:19 | |||
57 | 22-08-16 | 5:38 PM | 1 | 0:10 | |||
58 | 22-08-16 | 5:48 PM | 1 | 0:10 | |||
59 | 22-08-16 | 5:54 PM | 1 | 0:06 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E33 | =SUM(B33-B32) | |
E34 | =SUM(B34-B33) | |
E35 | =SUM(B35-B34) | |
E36 | =SUM(B36-B35) | |
E37 | =SUM(B37-B36) | |
E38 | =SUM(B38-B37) | |
E39 | =SUM(B39-B38) | |
E40 | =SUM(B40-B39) | |
E41 | =SUM(B41-B40) | |
E42 | =SUM(B42-B41) | |
E43 | =SUM(B43-B42) | |
E44 | =SUM(B44-B43) | |
E45 | =SUM(B45-B44) | |
E46 | =SUM(B46-B45) | |
E47 | =SUM(B47-B46) | |
E48 | =SUM(B48-B47) | |
E49 | =SUM(B49-B48) | |
E50 | =SUM(B50-B49) | |
E51 | =SUM(B51-B50) | |
E52 | =SUM(B52-B51) | |
E53 | =SUM(B53-B52) | |
E54 | =SUM(B54-B53) | |
E55 | =SUM(B55-B54) | |
E56 | =SUM(B56-B55) | |
E57 | =SUM(B57-B56) | |
E58 | =SUM(B58-B57) | |
E59 | =SUM(B59-B58) |