Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

Hinew field: elapsed time

Hi Community,

having a field called Elapsed time with the value of 253 15:43 (format day hh:mm)

253.............. day

15................ hh

43 .............. mm

How could i create 2 new fields? (day , hh)

I'm using

day(ElapsedTime)

hour(ElapsedTime)

but doesn't work.

3 Replies
MK_QSL
MVP
MVP

Hour(Interval#('253 15:43','D hh:mm'))

Interval(Interval#('253 15:43','D hh:mm'),'D')

Replace '253 15:43' with ElapsedTime

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi

a curiosity, converting the days in hh

I get a result with decimals

example

Formula:

=(Interval(Interval#([DELTA],'D hh:mm'),'D')*24

Result

1320,0666667 instead of 1320

May I fix a number with no decimals?

I tried

num((Interval(Interval#([DELTA],'D hh:mm'),'D')*24 , '#####0)

but doesn't work.

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

ok I solved

num(Interval(Interval#([DELTA],'D hh:mm'),'D')*24, '#####0')