Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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