Date and Time in Excel

Hi friends today we are discuss about Date and Time format in Excel. Excel automatically understands date and time typed in most of the common ways. Normally when you entered a date or time in a cell Excel automatically converts it in a serial number. The serial number represents the number of days from the beginning of the century until the date you type.


If your entry is recognized as a valid date or time format you will se the date or time on screen. Correctly entered date appear in the formula bar with the format mm/dd/yyyy, regardless of how the cell is formatted.


To enter a date, do this:
1. Select the cell in which you want to enter the date.
2. Type the date into the cell with any of these formats. For example to enter a date 5th January 2008 type:
1/05/2008
05-Jan-08
05-Jan
Jan-08
Also you can enter more many types how much you can think to enter a date in Excel. And with newer version of Excel the types of entered a date format is also increased.
You must be separate a date entry with the following things /,-, or use a space to separate a date but we recommended that u must be separate with a / or -.


To Enter a Time, do this;
1. Select the cell on which you want to enter the time.
2. Type the time in any of the following formats. For example to enter 1:32 PM, type:
13:32
13:32:00
1:32 PM
1:32:00 PM
The first two examples are from a 24-hour clock. If use a 12-hour clock. Follow the time with a space and A, AM, P, PM in either upper or lower case.


To enter the current date/time in a cell, do this: -

1. To enter current date in a cell first select the cell and press Ctrl + ; keys together
2. To Enter current time in a cell first select the cell and press Ctrl + : keys together


Tips: - To format a cell in default date format, select the cell and press Ctrl + # (means Ctrl +Shift + #)
To format a cell in default time format, select the cell and press Ctrl + @ (means Ctrl +Shift +@)


Now I think all of you become expert in a date and time format of Excel. We are quickly start our one most important step which name is Formulas of Excel, it is a long lesson so friend be prepared.