{"id":425,"date":"2018-06-28T09:02:08","date_gmt":"2018-06-28T09:02:08","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=425"},"modified":"2024-02-19T14:55:36","modified_gmt":"2024-02-19T14:55:36","slug":"formatting-date-and-time","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/","title":{"rendered":"Formatting Date and Time"},"content":{"rendered":"\n

You can format date and time in many different ways. Look at the following example to learn how to do it.<\/p>\n\n\n\n

Example 1:<\/strong><\/p>\n\n\n\n

Put the following date inside a cell: February 14, 2014 18:15:00<\/strong>. Right-click the cell, and then select Format Cells…<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the Format Cells window, the Number<\/strong> tab consists of four parts: Category, Sample, Type<\/strong> and Locale (location)<\/strong>.<\/p>\n\n\n\n

Click the Date<\/strong> position inside the Category<\/strong> box. On the right side, inside the Type<\/strong> box, different types of date and time formatting options will be displayed. Click one of them and then in the Sample<\/strong> box you will see the preview of the currently selected date, with the new formatting applied.<\/p>\n\n\n\n

Create your own date and time formats<\/h2>\n\n\n\n

There is a large number of combinations when it comes to date and time formatting, but sometimes you won\u2019t find any that meets your expectations. In such situations, Excel will let you create your own format that you can use later when working in Excel.<\/p>\n\n\n\n

Example 2:<\/strong><\/p>\n\n\n\n

Click the cell again and then open the Format Cells<\/strong> window. Choose the Custom<\/strong> item, which is located at the bottom, in the Category<\/strong> field.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can format date<\/a> and time by using many different combinations. In the table below, you can see which letters correspond to which type of formatting.<\/p>\n\n\n\n

For Date:<\/strong><\/p>\n\n\n\n

RESULT<\/strong><\/td>FORMAT<\/strong><\/td><\/tr>
Years: 00-99<\/td>y<\/td><\/tr>
Years: 1900-9999<\/td>yyy<\/td><\/tr>
Months: 1-12<\/td>m<\/td><\/tr>
Months: 01-12<\/td>mm<\/td><\/tr>
Months: Jan-Dec<\/td>mmm<\/td><\/tr>
Months: January-December<\/td>mmmm<\/td><\/tr>
Months: F-D<\/td>mmmmm<\/td><\/tr>
Days: 1-31<\/td>d<\/td><\/tr>
Days: 01-31<\/td>dd<\/td><\/tr>
Days: Mon-Sun<\/td>ddd<\/td><\/tr>
Days: Monday-Sunday<\/td>dddd<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

For Time:<\/strong><\/p>\n\n\n\n

RESULT<\/strong><\/td>FORMAT<\/strong><\/td><\/tr>
Hours: 0-23<\/td>h<\/td><\/tr>
Hours: 00-23<\/td>hh<\/td><\/tr>
Minutes: 0-59<\/td>m<\/td><\/tr>
Minutes: 00-59<\/td>mm<\/td><\/tr>
Seconds: 0-59<\/td>s<\/td><\/tr>
Seconds: 00-59<\/td>ss<\/td><\/tr>
Time: 10 AM<\/td>h AM\/PM<\/td><\/tr>
Time: 10:36 AM<\/td>h:mm AM\/PM<\/td><\/tr>
Time: 10:36:24 A<\/td>h:mm:ss A\/P<\/td><\/tr>
Time: 10:36:24.75 AM<\/td>h:mm:ss.00<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

You can format date and time in many different ways. Look at the following example to learn how to do it. Example 1:…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yoast_head":"\nFormatting Date and Time<\/title>\n<meta name=\"description\" content=\"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Formatting Date and Time\" \/>\n<meta property=\"og:description\" content=\"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T09:02:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:55:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Formatting Date and Time\",\"datePublished\":\"2018-06-28T09:02:08+00:00\",\"dateModified\":\"2024-02-19T14:55:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\"},\"wordCount\":341,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png\",\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\",\"name\":\"Formatting Date and Time\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png\",\"datePublished\":\"2018-06-28T09:02:08+00:00\",\"dateModified\":\"2024-02-19T14:55:36+00:00\",\"description\":\"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formatting Date and Time\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Formatting Date and Time","description":"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/","og_locale":"en_US","og_type":"article","og_title":"Formatting Date and Time","og_description":"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!","og_url":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/","article_published_time":"2018-06-28T09:02:08+00:00","article_modified_time":"2024-02-19T14:55:36+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Formatting Date and Time","datePublished":"2018-06-28T09:02:08+00:00","dateModified":"2024-02-19T14:55:36+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/"},"wordCount":341,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png","articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/","url":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/","name":"Formatting Date and Time","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png","datePublished":"2018-06-28T09:02:08+00:00","dateModified":"2024-02-19T14:55:36+00:00","description":"Learn how to format date and time in Excel. Choose from pre-made formats or customize your own. Follow our examples to get started!","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/format-cells-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/formatting-date-and-time\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Formatting Date and Time"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/425"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=425"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":13796,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/425\/revisions\/13796"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}