Date and Time Functions in Excel

This post will teach you about built-in Excel Date and Time functions which can be extract date and time information in various method to perform operations in Excel.

Follow the below methods to create date and time in excel using Shortcut keys and Functions or Formulas.

Method 1:

Press

Ctrl + Semicolon

to get date in required cell.

Press

Ctrl + Shift + Semicolon

to get time in required cell.

Method 2:

Using function

1. Using Today function to get date in particular cell.

=Today()

2. Using Now function to get time in particular cell.

=Now()

Cell "C2" is showing

=Now()

function and it returns Date and Time together in that cell.

We will take below example to understand easily.

Now we will try to separate the Time alone from that cell and display it in cell "D2".

Function:

=TIME(HOUR(C2),MINUTE(C2),SECOND(C2))

Using above formula, we can get time alone into different cell.

Also we can separate the Hour, Minute and Seconds with three different functions as shown below.

=HOUR()
=MINUTE()
=SECOND()

Thank You for visiting our website ExcelBoss.