Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ShellyG
Creator
Creator

Converting integer field to minutes

Hi all, 

I need some help regarding how to convert numeric/integer field into minutes. The field in question already contains the minutes in the following format - 2.00 (2 minutes), 3.00, 10.00, 116.00 etc...

When I want to do a sum to this field, I get very weird numbers, so I believe I need to convert it to minutes first.

Any ideas? 

Thanks!

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

You can sum integers for minutes and you should get a correct result ,assuming 116 is 116 minute rather than 1 hour, 16 minutes. If the latter is true, you would need to break it up, which I think should be:

Mod(100,YourField)  //= minutes part

+

Div(100,YourField)*60 //= hours part

View solution in original post

1 Reply
Or
MVP
MVP

You can sum integers for minutes and you should get a correct result ,assuming 116 is 116 minute rather than 1 hour, 16 minutes. If the latter is true, you would need to break it up, which I think should be:

Mod(100,YourField)  //= minutes part

+

Div(100,YourField)*60 //= hours part