Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
mack2018
Contributor II
Contributor II

Convert hour (numeric) value ( 1.25 ) to HH : MM format (1:25)

Hi, any Idea to convert from Hour in numeric Value (1.25) to HH:MM  format (1:25) ?

Labels (1)
2 Replies
marcus_sommer
MVP
MVP

Try it with: time(time#(Field, 'h.mm'))

- Marcus

sergio0592
Specialist III
Specialist III

Hi, try with

=Interval(1.25,'HH:MM')