# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
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
Creator III

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

Regards,

David

2 Replies
Creator III

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

Regards,

David

Creator II
Author

Thank you!