topic Re: Get time from numeric start value qlikview in QlikView https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957582#M328910 <HTML><HEAD></HEAD><BODY><P>try like this:</P><P>=interval(interval#(420, 'm'), 'hh:mm')</P></BODY></HTML> Tue, 29 Sep 2015 12:35:03 GMT avinashelite 2015-09-29T12:35:03Z Get time from numeric start value qlikview https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957581#M328909 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How do I get the timestamp from values like 0....420, 421, 422, 423....1430 where the values in the interval is minutes and the starttime is from 00:00 (12:00 a.m)?</P><P>Example 420 = 07:00 (7:00 a.m) and 1400 = 23:33 (11:33 p.m)</P><P></P><P>Thanks for suggestions</P></BODY></HTML> Tue, 29 Sep 2015 12:21:18 GMT https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957581#M328909 2015-09-29T12:21:18Z Re: Get time from numeric start value qlikview https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957582#M328910 <HTML><HEAD></HEAD><BODY><P>try like this:</P><P>=interval(interval#(420, 'm'), 'hh:mm')</P></BODY></HTML> Tue, 29 Sep 2015 12:35:03 GMT https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957582#M328910 avinashelite 2015-09-29T12:35:03Z Re: Get time from numeric start value qlikview https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957583#M328911 <HTML><HEAD></HEAD><BODY><P>SImply this:</P><P></P><P>=Time(Value / 1440)</P><P></P><P>(because there are 24*60 (1440) minutes per day)</P></BODY></HTML> Tue, 29 Sep 2015 12:37:15 GMT https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957583#M328911 jonathandienst 2015-09-29T12:37:15Z Re: Get time from numeric start value qlikview https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957584#M328912 <HTML><HEAD></HEAD><BODY><P>=Time(YourFieldName/60/24)</P></BODY></HTML> Tue, 29 Sep 2015 12:39:00 GMT https://community.qlik.com/t5/QlikView/Get-time-from-numeric-start-value-qlikview/m-p/957584#M328912 MK_QSL 2015-09-29T12:39:00Z