Dostupné formáty pre datum a čas v Office356 v OS Win 11

Question

Tvorba vlastných formátov pre datum a čas v Office356 v OS Win 11

Answer 1

In Microsoft 365 applications, including those on Windows 11, you can use various standard formats for date and time. Here are some examples of standard DateTime formats:

Standard DateTime Formats:

• US Format:
  • MM/DD/YY HH:MM AM/PM (e.g., 04/05/21 04:35 AM)
  • MM/DD/YY HH:MM:SS AM/PM (e.g., 04/05/21 04:35:55.553 AM)
• European Format:
  • DD-MM-YY HH:MM (e.g., 05-04-21 04:35)
  • DD-MM-YY HH:MM:SS (e.g., 05-04-21 04:35:55)

You can also create custom formats for date and time using specific format specifiers, such as:

• "d" for day of the month (1 to 31)
• "dd" for day of the month (01 to 31)
• "ddd" for abbreviated day name
• "dddd" for full day name

To create custom formats, you can refer to the specific format strings that suit your needs. This flexibility allows you to display dates and times in a way that is culturally appropriate or user-friendly based on your preferences.