1 Reply Latest reply on Apr 8, 2009 7:01 AM by TSGal

    Formatting a Time Field with a decimal digit

    Alexrowing

      Summary

      Formatting a Time Field with a decimal digit

      Description of the issue

      I try to format a field like this 7:26.4 but after I input a value , it will displace as 7:26.0. I have already format the number format to a decimal digit and the time format in mm:ss. Any help please.

        • 1. Re: Formatting a Time Field with a decimal digit
          TSGal

          Alexrowing:

           

          Thank you for your post.

           

          If you format the field to display mm:ss, then that is all you will display.  Instead, don't put any time formatting on the field.  Just set the Number formatting for one decimal place.  Then, you will see 7:26.4.  If you duplicate the record and add a summary field that is a total of the time field, then the result for the two records will display 14:52.8.

           

          TSGal

          FileMaker, Inc.