How to Calculate TIME in EXCEL

How to Calculate TIME in EXCEL

Excel can work with time very easily.

Time can be entered in various different formats and calculations performed.

See the Time sheet Example below:-

Typing Time

When time is entered into worksheet it should be entered with a colon between the hour and the minutes, such as 12:30, rather than 12.30

Excel can cope with either the 24 hours system or the am/pm system.To use the am/pm system you must enter the am or pm after the time.

You must leave a space between the number and the text.

Finding the difference between two times
You can subtract two time values to find the length of time between.

Note:- If the result is not shown correctly,You may need to reformat the answer.Look at the section about formatting further in this worksheet.

How To Apply Custom Formatting

1. Click on the cell which needs the format.or Shortcut Key:- CTRL+ 1

2. Choose the Format menu.

3. Choose Cells.

4. Click the Number tag at the top right.

5. Choose Custom.

6. Click inside the Type: box.

7. Type [hh]:mm as the format.

8. Click OK to confirm.

Formatting time

When time is added together the result may go beyond 24 hours.

Usually this gives an incorrect result, as in the example below.

To correct this error, the result needs to be formatted with a Custom format.