AnsweredAssumed Answered

Turning text into minutes

Question asked by DanielPinder on Apr 25, 2011
Latest reply on Apr 25, 2011 by DanielPinder


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?