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

How to get number of characters in cell Microsoft Excel / Use of LEN function (formula) in Microsoft Excel

LEN

Use of LEN function/formula in Microsoft Excel:

This formula/function helps to return the number of characters in a particular cell.

Formula:

The syntax of LEN function in Microsoft Excel is below.

=LEN(text)

Example :

Step 1: First type ADVANCEDMSEXCEL.BLOGSPOT.COM in cell B4 as per shown in below image.

Step 2: Type formula =LEN(B4) in cell B6 and press enter.

LEN

How to Rounds off number in MS Excel / How to Use FIXED function (formula) in Microsoft Excel

FIXED

Use of FIXED Function/Formula in Microsoft Excel:

This formula/Function helps to rounds a number to specified number of decimals in particular cell.
And also it formats the number in decimal format using a period and commas and returns the result as text.

Syntax/Formula :

The syntax of FIXED function in Microsoft Excel is below.

=FIXED(number,[decimals],[no-commas])

Example :

Step 1: First type any decimal number such as 5000000.96 in cell B4.

Step 2: Type formula =FIXED(B4,1,) in cell B6 and press enter.

FIXED

How to Capitalizes first letter of text in Microsoft Excel / Use of PROPER function/formula in Microsoft Excel

PROPER

Use of PROPER Function/Formula in Microsoft Excel:

This function/formula capitalizes the first letter in particular cell
and any other letters in text that follow any character other than a letter. Convert all other letters to 

lowercase letters.

Syntax/Formula :

The syntax of PROPER in Microsoft Excel is below.

=PROPER(?

Example :

Step 1: First type advanced ms excel.blogspot.com in cell B4 as per shown in below image.

Step 2: Type formula =PROPER(B4) in cell B6 and press enter.

PROPER