Custom Date or Time format in EXCEL
Determine the day of week for a given date in the cell. There are several solutions depending on the result we want to obtain: the day of the week (1 - Mon 2 - Tue, ...) and text form (Monday, Tuesday, ...) or you can simply change the cell format.
EXCEL stores TIME in numerical form (fractional part of the number). For example, of 0.75 corresponds to 18:00, 0,5 - 12:00. If, for some reason, the TIME values stored in decimal form, for example, 10.5 hours, they can be converted into the standard time format (hours : minutes : seconds). The article also shows how to convert the number of 1800 to 18:00.
When creating formulas to display in the cell phrase containing the text and date, e.g. "Today 02.10.10", it is possible to get such result: "Today 40453", i.e. a date will be reflected in numerical form. Solve the problem by first converting the date to text in the required format.
EXCEL in the Time format does not display milliseconds, but sometimes it's required. Using custom formatting to display the milliseconds.
If you often enter data in time format (2:30:55), the need to enter a colon ":" seriously reduces speed. The question arises: is it Possible to do without entering the colon?
a Custom format is the display format for the value specified by the user. For example, the date 13/01/2010 can be displayed as: 13.01.2010 or 2010_01_13 or 13-Jan-10.
IN EXCEL the date corresponds to a positive integer, and the time of day is the fractional part of the number.