Using '&' in Microsoft Excel

To connect strings in Microsoft Excel, simply use '&'. 

Example :

This will return the following results:

Calculate between two times (2)

Using TEXT formula to calculate time. 

Use =TEXT(End time-Start time,"format to use") to calculate between two times. Simply replace the format to use with:

h = hour

mm = minutes

ss = seconds.

Example:

The result would be,

You can also personalize the formula.

This will return the result based on each preference.

Calculate between two times (1)

 How to calculate between two times? 

To get the time difference, just use End Time - Start time. In this case, it would be =B2-A2.

The answer should be 9:14:30, 9 hours 14 minutes and 30 seconds.

Or you can use HOUR, MINUTE and SECOND formula.

The result would depend on which formula that you choose.

How to calculate age using Microsoft Excel

 To calculate age using Microsoft Excel, just use the simple formula DATEDIF. Example would be =DATEDIF(date to compare, current date, "y")

For example, 

Here's the two dates to compare. In selected destination cell, type =DATEDIF(A2,B2,"y")

You'll get the specific age as the result.

AVE

Formula AVERAGE is used to search the average value. Example of formula  is =AVERAGE(RANGE X:RANGE Y)

Example 1 : To find the average value of a row or column. 

In selected destination cell, type =AVERAGE(RANGE X:RANGE Y). In this example, the formula would be =AVERAGE(B2:B7).

Hit the enter button to get the average result.

Use the increase and decrease decimals to get the best value. Go to Home->Number-> Choose either to increase or decrease decimals

Example 2 : To find average value of multiple rows or columns.

In selected destination cell, type =AVERAGE(RANGE X:RANGE Y). In this example, the formula would be =AVERAGE(B2:C7).

Hit the enter button to get the average result.

How to increase and decrease decimal value

 How to increase and decrease the decimal value?

1) Choose the selected cell.

2) Go to Home->Number

3) Choose either to increase or decrease the value. 

MAX

Formula MAX is used to search the least value. Example of formula is =MAX(RANGE X:RANGE Y)

Example 1 : To find the maximum value of a row or column. 

In selected destination cell, type =MAX(RANGE X:RANGE Y). In this example, the formula would be =MAX(B2:B7).

Hit the enter button to get the maximum result.

Example 2 : To find maximum value of multiple rows or columns.

In selected destination cell, type =MAX(RANGE X:RANGE Y). In this example, the formula would be =MAX(B2:D7).

Hit the enter button to get the maximum result.

MIN

 Formula MIN is used to search the least value. Example of formula is =MIN(RANGE X:RANGE Y)

Example 1 : To find the minimum value of a row or column. 

In selected destination cell, type =MIN(RANGE X:RANGE Y). In this example, the formula would be =MIN(B2:B7).

Hit the enter button to get the minimum result.

Example 2 : To find minimum value of multiple rows or columns.

In selected destination cell, type =MIN(RANGE X:RANGE Y). In this example, the formula would be =MIN(B2:D7).

Hit the enter button to get the minimum result.

SUM

 SUM  - to sum/calculate a total of numbers. Example of formula would be =SUM(Range X:Range Y)

  Example 1

Select row or column to calculate the total of values. In this example, the row of values would be A2 to A7. 

To calculate the total values, type =SUM(Range X:Range Y) in the destination cell to display. In this example, it would be =SUM(A2:A7). Hit Enter to display the calculation result.

Example 2

We can also use SUM to calculate the total of multiple rows or column. For example, this row A and row B. 

We're going to calculate values in column A and column B. 

In selected cell for display value, type =SUM(A2:B7). Hit Enter to calculate the result.