Hi
Glenn,
The formula you provided is actually a
custom time format in Excel. Here's what it means:
- [$-F400] - This is a language code that specifies the format for the time. In this case, it's using the language code for English (South Africa).
- h:mm:ss - This specifies the format for the time itself. "h" represents the hour in 12-hour format, "mm" represents the minutes, and "ss" represents the seconds.
- AM/PM - This specifies whether the time is in the morning or afternoon.
So, when you apply this custom time format to a cell in Excel, it will display the time in the format of "
hour:minute:second AM/PM" with the language code for
English (South Africa).
To apply this custom time format to a cell in Excel 2007, you can follow these steps:
- Select the cell or range of cells that you want to format.
- Right-click and select "Format Cells" from the context menu.
- In the Format Cells dialog box, select the "Custom" category.
- In the "Type" field, enter the custom time format: [$-F400]h:mm:ssAM/PM
- Click "OK" to apply the custom time format to the selected cells.