Home MS Excel TutorialExcelTips and Tricks How To Format Date And Time In Excel

How To Format Date And Time In Excel

by Easy Excel Tutorials

How To Format Date And Time In Excel

How to Easily Format Date and Time in Excel Format of date and time can be tough, but it will easily be performed together with me, follow me as I format date and time.

Click on a cell (1), type in =DATE(2014(year);10(month);05(day))

(2), and press enter.

type date

Click on another empty cell (1), and type in =TIME(hour;minutes;seconds)

(2), and finally press enter.

type time

Right click on the time, and choose format cells.

format cells

Click on date (1), and choose desired format (2), before clicking ok.

choose format

Repeat previous step, but this time choose time (1), the type you want (2), and then press ok (3).

choose time format

With that knowledge you will be able to use date duration calculator without any problems.


You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References

You may also like