Date and Time Formats in Excel

Date & Time Formats in Excel

MS Excel supports multiple pre-defined as well as custom formats for Date and Time.

To set/change the Date and Time format, follow the steps below:

1. Enter a date and time value in cell A1

2. Right click on the cell having date and time value and select Cell Format from the context menu

In first demonstration, we will set the value to date only

1. On Format Cells window, select Date from Category and under Type section, select dd-mmm-yy format

2. The output would set the value to Date only format

In second demonstration, we will set the value to time only

1. On Format Cells window, select Time from Category and under Type section, select hh:mm:ss format

2. The output would set the value to Date only format

In final demonstration, we will set a custom value of date and time both

1. On Format Cells window, select Custom from Category and under Type section, type dd-mmm-yy hh:mm:ss in the type textbox

2. The output would set the value to Date and Time format