Return to FileMaker.com
Convert number with decimals to minutes
FMP 11Mac and PC
We have values like: 9.206 minutes and we would like to convert these values to display in minutes so it would appear as 9:12:36
Any ideas? Can I use the Time ( ; ; ) function to do this and will it display the :36 of the time above?
Do it like this:
YourMinutesNumberField * 60
and specify Time as the return type.
Retrieving data ...