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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Dayna
Creator II
Creator II

Converting an integer of minutes to hours, minutes and seconds

Hi All,

I tried to search the forums but couldn't find a response that was clear for this... I have a value of time in minutes that I'd like to format as hhh:mm:ss, I was thinking interval but this is giving me a really high number.


For example, my value in minutes is 48.9666666667

I was thinking that interval needs to work in seconds so I divided this by 60 to give 0.81611111111

If I then do interval as: interval(time/60,'hhh:mm:ss) I get 019:35:12.

This is clearly wrong, as I know the value is 48 minutes and 59 seconds. Can someone help how I should proceed here, please?

Kind Regards,

Dayna

1 Solution

Accepted Solutions
daveamz
Partner - Creator III
Partner - Creator III

You can use =Interval(48.9666666667/60/24)

Regards,

David

View solution in original post

2 Replies
daveamz
Partner - Creator III
Partner - Creator III

You can use =Interval(48.9666666667/60/24)

Regards,

David

Dayna
Creator II
Creator II
Author

Thank you!