Tech Tip: Displaying a number as time
PRODUCT: 4D | VERSION: | PLATFORM: Mac & Win
Published On: February 25, 2000
You can display a number as time (with a time format) by using "&/" followed by a digit. Time is determined by calculating the number of seconds since midnight that the value represents. The digit in the format corresponds to the order in which the time format appears in the Format drop-down menu.
For Example:
&/5
...corresponds to the 5th time format in the pop-up menu, specifically the AM/PM time. A number field with this format would display 25000 as:
6:56 AM