Specifying formats for time fields
You can control how FileMaker Pro displays time values in fields.
To specify formats for time fields:
1.
In Layout mode, select one or more time fields or calculation fields with a time result.
For more information, see Selecting objects.
2.
Choose Format menu > Time.
3.
In the Time Format dialog box, select the formats you want to use.
You see an example of the options you choose in the Sample area.
 
To display times
Do this
Exactly as entered
Select Leave data formatted as entered.
In a predefined format
Select Format as and choose a format. Then specify one or more of the following format options:
  •
a different value for Separator (such as a period or a space) or Kanji format if you’re using a font that contains Japanese characters.
  •
12-hour or 24-hour notation.
  •
Custom prefix or suffix text such as the designations for before noon and after noon.
With leading characters
For Leading Characters, choose options for Hours, Minutes and Seconds, or both. (This option is not available if you've chosen Leave date formatted as entered.)
With different text formatting
Click Text Format. In the Text Format dialog box, choose text attributes, then click OK. For more information, see Specifying text formats for fields.
Using a different Japanese time display (if you’re using a font that contains Japanese characters)
For Display As, choose a display type.
4.
Click OK.
You’re finished unless the time format you chose displays seconds. If you want to format the seconds component to display fractional seconds, continue with the next step.
5.
Choose Format menu > Number.
6.
In the Number Format dialog box, select the formatting options you want.
Only two options affect the display of the seconds component: Fixed number of decimal digits and Decimal separator. The remaining options have no effect. For more information, see Specifying formats for fields containing numbers.
7.
Click OK.
Notes
  •
To format a time symbol (which displays the current time), select the symbol “::” (two colons) in Layout mode, choose Format menu > Time, and then format it as you would a time field as described above. For more information about the time symbol, see Inserting the date, page number, or other variable onto a layout.
  •
For more information about defining time fields, see Defining time fields.
Was this topic helpful? Send feedback.