Converting integer field to minutes

[ShellyG]

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!

[Or · Accepted solution]

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