Excel Date and Time Formats - Easy Excel Tutorial http://www.excel-easy.com/examples/date-time-formats.
html
Excel Easy
#1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us
Date and Time Formats
Dates and times in Excel can be displayed in a variety of ways. To apply a Date or Time format, execute the
Chapter
following steps.
1. Select cell A1. Format Cells
Learn more, it's easy
Decimal Places
Date and Time Formats
2. Right click, and then click Format Cells.
Fractions
LearnQuest IT Currency vs Accounting
Text to Numbers
Training Numbers to Text
Learn from the Industry Custom Number Format
Leader! Custom Group &
Format Painter
Individual Training.
Cell Styles
Themes
3. In the Category list, select Date, and select a Date format. Download Excel File
1 of 4 08-11 05:23 PM
Excel Date and Time Formats - Easy Excel Tutorial http://www.excel-easy.com/examples/date-time-formats.html
date-time-formats.xls
Follow Excel Easy
4. Click OK.
Note: to apply a Time format, in the Category list, select Time.
5. Dates are stored as numbers in Excel and count the number of days since January 0, 1900. Times are handled
internally as numbers between 0 and 1. To clearly see this, change the number format of cell A1, B1 and C1 to
General.
2 of 4 08-11 05:23 PM
Excel Date and Time Formats - Easy Excel Tutorial http://www.excel-easy.com/examples/date-time-formats.html
Note: apparently, 41083 days after January 0, 1900 is the same as June 23, 2012. 6:00 is represented as 0.25
(quarter through the day).
6. You can enter times as 6:00, but Excel displays this time as 6:00:00 AM in the formula bar. AM is used for times
in the night and morning. PM is used for times in the afternoon and evening.
7. Change the number format of cell C1 to Date only.
Note: cell C1 still contains the number 41083.25. We only changed the appearance of the number, not the number
itself.
8. Finally, if you cannot find the right date or time format, create a custom date or time format.
3 of 4 08-11 05:23 PM
Excel Date and Time Formats - Easy Excel Tutorial http://www.excel-easy.com/examples/date-time-formats.html
Be Certified in Big Data
Step by Step Training by Experts. 45 hrs, Weekend Course, Better Jobs
niit
Monthly Investment Plan
Class 1-10 GK Questions
Freelance Excel
Nifty Future Option tips
Start Download
Start Download
Find Sunny Car Offers
Start a Nursery School
Do you like this free website? Please follow us on Google+
Learn more about formatting cells, use the side menu >>
Go to Top: Date and Time Formats | Go to Next Chapter: Find & Select
COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.
EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO
4 of 4 08-11 05:23 PM
