How to create time in AM/PM format / How to use TIME function (formula) in Microsoft Excel

TIME

Use of TIME function/formula in Microsoft Excel:

This function return the particular time in hh:mm AM/PM format

Syntax/Formula:

The syntax of TIME function in Microsoft Excel is below.

=TIME(hours, minutes, seconds)

Example 1:

Step 1: First type hour 25 in cell B5, minute 12 in cell B6, and second 19 in cell B7.

Step 2: Type formula =Time(B5,B6,B7) in cell B9 and press enter.

TIME

Example 2:

Step 1: First type hour 20 in cell B5, minute 12 in cell B6, and second 19 in cell B7.

Step 2: Type formula =Time(B5,B6,B7) in cell B9 and press enter.

TIME