spot_img

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.

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell