Windows 10: Create custom date and time formats

Hi all, I would like to add custom date time formats for my windows 11 laptop, as I want a specific format not currently found. Is this possible?

:)

 

Changing Time Format

Hi Mary,

There's a possibility that the set up time format in your computer Basic Input/Output System (BIOS) is military time. To have this checked, you can try to reset the time of your computer through Control Panel. See the steps below on how to do
so:

• Open Control Panel > Clock, Language, and Region >
  Change date, time, or number formats. This would open the
  Region window.
• From there, click on Additional settings at the bottom part. It will open the Customize Format.
• Click Reset; then, OK.

The steps should work; however, if not, we suggest that you contact manufacturer and have the BIOS time checked.

Let us know what happens after doing the suggestions .

 

Change Date Format

Customize the date and time format:

Click the following link to know the steps.

https://www.howtogeek.com/247141/how-to-change-the-format-of-dates-and-times-in-windows/

 

Date and Time Formatting

Hi PhilWarren1

Greetings! I am Vijay, an Independent Advisor. You will have to differentiate between date and time as both are stored as numbers only. Hence, if a cell you are going to format as date, you should put date only and if you are going to format a cell as time,
you should put time only.

For date, you need to use following custom format (You will need to use full 6 digits, hence you need to enter 100719 not 10719)

00\/00 \/00

For time, you need to use following custom format

00\:00

This changes the display not the exact value.

If you need to change it to date and time format not only in display, VBA code will be required. Let me know that you don't need custom format method but VBA code method,