Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
=Time(Interval#(YourTimeField,'ss'))
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 |
Seems, This consist as different time
Can you try this?
Time(Interval#(fabs(TIME),'ss')) * 60 // If not, Try with / 60
I haven't asked you to use Fabs function... !!!
Hello
my field in negative this is why I am using fabs function
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 |
Load *,Time(Interval#(Fabs(TimeField),'ss')) as Time Inline
[
TimeField
36
12
24
24
95
-225
-100
128
];
I am sorry, my time field is in minutes...
use
Time(Interval#(Fabs(TimeField),'mm')) as Time