Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
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)
• ### General Question

1 Solution

Accepted Solutions
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

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

Tags
Community Browser