Turning text into minutes
I have a time calculator built into my db that requires a denominator to be changed frequently. I want a text or number field that I can simply enter a count of minutes (say, 150 minutes) and update the amount of minutes at will. I don't want anything expressed in hh:mm:ss and the major concern is that I don't want to have to enter minutes as: "0:150:00" just to satisfy FMP's time format.
I tried making a calculation:
GetAsTime ( minutesInput )
where minutesInput is the text field containing an integer, but the problem is that the calc uses the number I enter as the hours, not the minutes. What is the best way to tell it to calculate my entry as minutes, not hours?