About time fields
Use time fields to store:
 •
times you need to sort or search through
 •
times used in calculation formulas or summary fields
Notes
 •
The separators in time fields and the order in which the time parts appear depend on the system formats set for the file and the display format for the field. For information on changing the display format for a field (for example, 11:09 PM or 23:09), see Specifying formats for time fields.
 •
FileMaker Pro stores times as the number of seconds since midnight. Therefore you can calculate times before or after a given time by subtracting or adding a number of seconds. For example, in a calculation field whose result is a time, the following formula calculates the time one hour (60 seconds to a minute * 60 minutes to a hour = 3600 seconds) after the value in a time field named TimeStarted:
TimeStarted + 3600
 •
If you are using FileMaker Pro Advanced, you can copy field schemas from one file and paste them into the same file or some other file. See Copying and pasting field schemas (FileMaker Pro Advanced).
Related topics 
About defining database fields
Working with data in time fields
Specifying formats for time fields
Was this topic helpful? Send feedback.