Discussion Board for collaboration on QlikView Scripting.
Typo should be 4,2 for mid, not 3,3. This also "assumes" the hour part of your string is always 2 digits.
Time(MakeTime(num(left(FieldName,2)), num(mid(FieldName,4,2))),'hh, m')
Rob's answer of interval does not have this restriction so I would go with that.
Or may be this
LOAD RowNo() as RowNum,
Num(Interval#(Time, 'h:mm:ss'))*24 as [Time in hour];
LOAD * INLINE [
Thank you it works perfectly!
It was easy in fact..