Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
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
daveamz01
Creator III
Creator III

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

Regards,

David

View solution in original post

2 Replies
daveamz01
Creator III
Creator III

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

Regards,

David

Dayna
Creator II
Creator II
Author

Thank you!