Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator III
Creator III

Re: Converting an integer of minutes to hours, minutes and seconds

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

Regards,

David

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Re: Converting an integer of minutes to hours, minutes and seconds

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

Regards,

David

View solution in original post

Highlighted
Creator
Creator

Re: Converting an integer of minutes to hours, minutes and seconds

Thank you!