Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tincholiver
Creator III
Creator III

time format

Hello everyone:

I don't know how to solve the following time format, which is the following.

1.50 is the value of the field, but it should be read as 1:30 since 50 is the percentage not the minutes.

Any function to solve this?

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

If you simply divide by 24 and display as duration (QS) or Interval (QV), this should be correct as-is.

Or_0-1656429575543.png

 

View solution in original post

2 Replies
Or
MVP
MVP

If you simply divide by 24 and display as duration (QS) or Interval (QV), this should be correct as-is.

Or_0-1656429575543.png

 

tincholiver
Creator III
Creator III
Author

I work perfectly.
In the script add :

interval(time/24) and that's it, I'm converted!

Thanks a lot