Klokkeslet data
Hej jeg har føldende data jeg vil sorter i intervallerTID SALG
00:08:15 1520,00
10:02:38 299
10:03:40 169,75
10:05:16 746,7
10:04:31 150,85
10:05:57 2.055,00
14:51:44 908
10:12:53 538
10:09:50 207,55
10:09:46 57,75
10:12:16 246
10:14:33 106
10:12:56 77,1
10:17:40 598
10:13:46 132,3
10:14:10 849
10:14:53 1.083,00
10:16:09 62
10:20:11 2.799,00
10:18:12 59
10:19:58 173
10:22:37 666,45
10:25:36 27,75
10:23:59 81,4
10:24:38 566
10:26:55 37,75
10:31:00 61,45
10:29:59 163,4
10:33:20 203,65
10:33:32 759,2
10:33:21 28,15
10:33:19 59
11:21:20 2.460,00
11:17:15 248
11:18:27 5,45
10:42:35 75
10:43:12 118
10:47:04 97,95
10:49:23 640,65
10:50:39 2
10:53:22 70,5
11:01:46 2.721,60
11:00:22 859,5
11:02:52 138
11:02:01 129
11:02:59 743
11:03:51 112,85
11:05:27 82
11:04:45 188,95
11:08:40 -220
11:11:28 125,7
11:17:03 284,95
11:14:14 -3.456,65
11:15:39 540,15
11:16:13 3.456,65
11:19:27 91
11:17:43 20,45
11:37:57 405,5
11:18:34 418,45
15:44:43 849
11:20:40 37,5
11:21:26 118
11:22:03 15,5
11:24:56 2.605,60
11:22:57 218,5
11:23:54 10,5
11:24:45 167,6
11:27:41 257,9
11:27:54 80
11:28:41 110
osv.
det jeg ønsker at at jeg får salg pr time (eller anden interval) evt dato ud i et regneark
til min timeplanlægning
excel 2007
Peter
