time

master_student — Mon, 15 May 2017 08:41:48 GMT

Hello Guys,

I have a field in seconds. I would like to convert it into time (minutes / hours). I used this formula : Time(Time#(fabs(TIME), 'ss'), 'h:mm')

but the result is wrong

any help please?

Thanks

Re: time

MK_QSL — Mon, 15 May 2017 08:46:15 GMT

Try this

=Time(Interval#(YourTimeField,'ss'))

Re: time

master_student — Mon, 15 May 2017 08:54:57 GMT

I tried your solution Time =Time(Interval#(fabs(TIME),'ss')) and here's the result :

TIME en second	TIME
36
12	00:00:02
24	00:00:04
24	00:00:04
95	00:00:19
225	00:00:45
100
80	00:00:20
108	00:00:27
2118
1416
705
15
324
150	00:00:30
225
260	00:00:52
2118
732	00:02:02
20	00:00:02
10	00:00:02
132
95	00:00:19
95
5
10	00:00:02
670	00:02:14
0
135	00:00:27
135	00:00:27
4	00:00:01
85	00:00:17
85	00:00:17
174
1368
85	00:00:17
480
528
48
180
175	00:00:35
126
126
126	00:00:21
384
152	00:00:38
20
5	00:00:01
190	00:00:38
12	00:00:03
30	00:00:05
30	00:00:05
490
275
48	00:00:08
48	00:00:08
240
672
90
836
104	00:00:26
180
165
655
190
318
40	00:00:10
306	00:00:51
306	00:00:51
72	00:00:12
72	00:00:12
44	00:00:11
420
5	00:00:01
845
486
372
96
24	00:00:04
192
192
375
5	00:00:01
116	00:00:29
84	00:00:28
92	00:00:23
200
40	00:00:04
52	00:00:13
84
125	00:00:25
6	00:00:01
30	00:00:03
760	00:02:32
135	00:00:27
135	00:00:27
48	00:00:08
48	00:00:08
1098
348
60	00:00:10
144	00:00:24
102	00:00:17
840	00:02:20
18
6	00:00:01
395
72
260
135	00:00:27
125
125	00:00:25
24	00:00:04
24	00:00:04
12
36	00:00:03
18	00:00:03
28
124	00:00:31
792
312
234
12	00:00:02
68	00:00:17
762
196	00:00:49
196	00:00:49
225
4	00:00:01
4	00:00:01
90	00:00:18
45
35
20	00:00:04
430
270	00:00:54
20	00:00:04
55
88	00:00:22
296
488
1840
20	00:00:04
380
176
120	00:00:24
132	00:00:22
132	00:00:22
108	00:00:18
108	00:00:18
340	00:01:08
24	00:00:04
24	00:00:04
192
350
112	00:00:28
132
40
10	00:00:02
180
5	00:00:01
124	00:00:31
316
112
124	00:00:31
1385
2015	00:06:43
264
368
125	00:00:25
125	00:00:25
108
160
15	00:00:03
160	00:00:32
128
28
330
15	00:00:03
15	00:00:03
225	00:00:45
12	00:00:02
130	00:00:26
30	00:00:06
45	00:00:15
16	00:00:04
240	00:00:24
80	00:00:16
132	00:00:33
120	00:00:24
1668
1960	00:08:10
256
20	00:00:02
165	00:00:33
625	00:02:05
102
24	00:00:04
252
42	00:00:07
42	00:00:07
220
255
25	00:00:05
96	00:00:24
45
45
8
336
180	00:00:36
1145
315	00:01:03
170
5	00:00:01
130
210
605
1734	00:04:49
1734	00:04:49
120
60
110	00:00:22
51	00:00:17
834
60	00:00:15
210	00:00:42
532
80	00:00:20
24	00:00:04
24	00:00:04
42
12
40
120
110
35	00:00:07
180	00:00:45
75	00:00:15
424
692
10	00:00:02
10	00:00:02
245
245
440
60
8	00:00:02
240
42
42
100	00:00:20
1210	00:04:02
100
720
36	00:00:06
100	00:00:20
190	00:00:38
10	00:00:02
18	00:00:03
18	00:00:03
360
42	00:00:07
210
125
78
816	00:02:16
835
840	00:02:48
210	00:00:42
35
5	00:00:01
16	00:00:04
660	00:02:45
660
330	00:01:06
120	00:00:24
25	00:00:05
56
15
65	00:00:13
10	00:00:02
10	00:00:02
150
150
15	00:00:03
330
12
85
85	00:00:17
260
120	00:00:24
15	00:00:03
15	00:00:03
12	00:00:02
12	00:00:02
605
85	00:00:17
256
12
78
225	00:00:45
128	00:00:32
12	00:00:01
6	00:00:01
285
348	00:01:27
4	00:00:01
15	00:00:03
196
25
200	00:00:40
128
342
92	00:00:23
190
195
1150
1554	00:04:19
1554	00:04:19
10	00:00:02
10	00:00:02
385
15
42	00:00:07
42	00:00:07
138
136
10	00:00:02
10	00:00:02
5
1962
1506
396
15	00:00:03
15	00:00:03
280
10	00:00:02
2292
738
75	00:00:15
885	00:02:57
304
35	00:00:07
10	00:00:02
110
6
395
15	00:00:03
110	00:00:22
120
78	00:00:13
450	00:01:15
70
60
108	00:00:18
75
45	00:00:09
156	00:00:39
60
90
325
130
852
140	00:00:28
140	00:00:28
60	00:00:10
36	00:00:06
954	00:02:39
60
282
276	00:00:46
290
78
258	00:00:43
258	00:00:43
665
120	00:00:24
156
156
12
116	00:00:29
3
50	00:00:10
240
112	00:00:28
4
175	00:00:35
1700
715	00:02:23
18	00:00:03
4	00:00:01
327
285
168	00:00:28
312
12	00:00:01
40
15	00:00:03
80
150
15	00:00:03
12
3	00:00:01
100
195
5	00:00:01
360
116
585
66	00:00:11
24	00:00:06
1190
530
320	00:01:04
90	00:00:18
70	00:00:14
270
356
24	00:00:06
1356
680
380	00:01:16
1308
1332
240
132
10	00:00:02
5	00:00:01
25	00:00:05
125	00:00:25
108
20	00:00:04
126
1302
100
195
120	00:00:24
95	00:00:19
75	00:00:15
2330	00:07:46
3
280	00:00:56
0
126
6	00:00:01
370
76	00:00:19
245
235
20	00:00:04
120	00:00:24
18	00:00:03
200
24	00:00:04
24	00:00:04
590
330
78	00:00:13
265
78	00:00:13
78	00:00:13
138
18	00:00:03
145
152
304
112
12	00:00:02
12	00:00:02
145
20	00:00:02
10	00:00:02
150
130	00:00:26
415	00:01:23
56	00:00:14
212
80	00:00:16
188	00:00:47
420
18	00:00:03
18	00:00:03
165	00:00:33
324
24	00:00:04
144	00:00:36
100	00:00:25
4	00:00:01
840
840
155
90	00:00:18
216
10
740
100	00:00:20
100	00:00:20
50
162
240	00:00:48
12	00:00:02
36	00:00:03
100
545	00:01:49
155	00:00:31
760	00:02:32
75
135
284
135	00:00:27
5
28
72
10	00:00:02
240
1266
125
300	00:01:00
20
85
85
108	00:00:27
175
152	00:00:38
152	00:00:38
148
36	00:00:06
36	00:00:06
72
110
60	00:00:10
60	00:00:10
100
820	00:02:44
825	00:02:45
16
610
300
12	00:00:02
12	00:00:02
265	00:00:53
33	00:00:11
20
252
5	00:00:01
144	00:00:24
168	00:00:28
105
15	00:00:03
100
48
15	00:00:03
100	00:00:20
332
168	00:00:28
30	00:00:05
215
215
205
205
475
18	00:00:03
18	00:00:03
575
135	00:00:27
100	00:00:20
90
1008
4	00:00:01
1476
1476
210
40	00:00:08
40	00:00:08
10	00:00:02
220	00:00:44
220	00:00:44
18
18
595
12	00:00:02
12	00:00:02
54	00:00:09
8
30
260
114	00:00:19
108	00:00:18
80
18	00:00:03
18	00:00:03
132
280	00:00:56
60
50
5	00:00:01
12	00:00:03
6	00:00:01
6	00:00:01
42
390	00:01:05
430
15	00:00:03
1020	00:03:24
8	00:00:02
10	00:00:02
114	00:00:19
114	00:00:19
55	00:00:11
55	00:00:11
384
840
188
295
18	00:00:03
18	00:00:03
55
105	00:00:21
1435	00:04:47
702
702
145
15	00:00:03
15
128
72	00:00:12
72	00:00:12
12	00:00:02
12	00:00:02

Re: time

Anil_Babu_Samineni — Mon, 15 May 2017 08:58:31 GMT

Seems, This consist as different time

Can you try this?

Time(Interval#(fabs(TIME),'ss')) * 60 // If not, Try with / 60

Re: time

MK_QSL — Mon, 15 May 2017 08:58:31 GMT

I haven't asked you to use Fabs function... !!!

Re: time

master_student — Mon, 15 May 2017 09:11:21 GMT

Hello

my field in negative this is why I am using fabs function

Re: time

master_student — Mon, 15 May 2017 09:12:50 GMT

it gives wrong result Anil :

TIME en second	TIME
36
12	3,86E-07
24	7,72E-07
24	7,72E-07
95	3,67E-06
225	8,68E-06
100
80	3,86E-06
108	5,21E-06
2118
1416
705
15
324
150	5,79E-06
225
260	1,00E-05
2118
732	2,35E-05
20	3,86E-07
10	3,86E-07
132
95	3,67E-06
95
5

Re: time

MK_QSL — Mon, 15 May 2017 09:21:34 GMT

Load *,Time(Interval#(Fabs(TimeField),'ss')) as Time Inline

[

TimeField

-225

-100

128

];

Re: time

master_student — Mon, 15 May 2017 10:48:23 GMT

I am sorry, my time field is in minutes...

Re: time

MK_QSL — Mon, 15 May 2017 10:49:51 GMT

use

Time(Interval#(Fabs(TimeField),'mm')) as Time

topic Re: time in QlikView

time

Re: time

Re: time

Re: time

Re: time

Re: time

Re: time

Re: time

Re: time

Re: time