Get time from numeric start value qlikview

[#1]

Hi all,

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)?

Example 420 = 07:00 (7:00 a.m) and 1400 = 23:33 (11:33 p.m)

Thanks for suggestions

[avinashelite]

try like this:

=interval(interval#(420, 'm'), 'hh:mm')

[jonathandienst · Accepted solution]

SImply this:

=Time(Value / 1440)

(because there are 24*60 (1440) minutes per day)

[MK_QSL]

=Time(YourFieldName/60/24)