What does this formula mean [$-F400]h:mm:ssAM/PM
 

What does this formula mean [$-F400]h:mm:ssAM/PM

I am using Excel 2007. I have a spreadsheet I'm trying to understand and
when I custom format on a time value in the spreadsheet the above formula
shows
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa

Answer: What does this formula mean [$-F400]h:mm:ssAM/PM
 

Hi Glenn,

The formula you provided is actually a custom time format in Excel. Here's what it means:

1. [$-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).
2. 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.
3. 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:

1. Select the cell or range of cells that you want to format.
2. Right-click and select "Format Cells" from the context menu.
3. In the Format Cells dialog box, select the "Custom" category.
4. In the "Type" field, enter the custom time format: [$-F400]h:mm:ssAM/PM
5. Click "OK" to apply the custom time format to the selected cells.

What does this formula mean [$-F400]h:mm:ssAM/PM
 

Glenn,

This is what's called setting the Locale or region format for the time.

Select a cell, right click and format and you will see a dropdown on the
right containing various regions. Select one of these and the regional
convention for the date is applied to the cell

$-F400 is UK, it may be others i'm not sure
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Glenn" wrote:

What does this formula mean [$-F400]h:mm:ssAM/PM

I am using Excel 2007. I have a spreadsheet I'm trying to understand and
when I custom format on a time value in the spreadsheet the above formula
shows
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa

What does this formula mean [$-F400]h:mm:ssAM/PM
 

Glenn, this is the locale ID assigned by Microsoft. You may please refer the
below for details

http://office.microsoft.com/en-us/ex...346351033.aspx

--
Jacob (MVP - Excel)


"Glenn" wrote:

What does this formula mean [$-F400]h:mm:ssAM/PM

I am using Excel 2007. I have a spreadsheet I'm trying to understand and
when I custom format on a time value in the spreadsheet the above formula
shows
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa