Microsoft Excel (Format hh.hh.mm.ss), How to do apply given format in excel sheet ?

Question

Microsoft excel Help

Assumption
It is a figure having following format
xx.xx.xx. where maximum limit (100%) of figures are
12.30.60.60 respectively [Like hh.hh.mm.ss]

Now - - - -

Example of Addition is
12.22.59.59
+ 01.02.35.52
.01.02
01.25.36.58 (Answer)


Example of Subtraction is as under
12.04.59.59
- 01.28.35.52
01
10.06.24.07 (Answer)

How can I do this in Excel work book ?

Any body have knowledge in Excel ?

Answer 1

1. select the cells you wan to be formatted in time

2. bring the Mouse pointer to format (in the menu bar)

3. choose cell

4. select time

5. encode your time

6. apply the necessary formula that you want (whether it is subtraction or addition)



hope this helps

Answer 2

Word and Excel 2007 can handle the older format, but they may not be set up to automatically open when you double-click on one of those documents. Try this: 1. In Windows Explorer, find a .doc file. 2. Right-click on it and select Open With. 3. If Microsoft Word shows up in the Recommended list, select it. 4. If it does not, click the Browse button. Navigate to the directory C:\Program Files\Microsoft Office\Office 12. Find and select the file winword.exe. 5. In either case, check the checkbox Always use the selected program to open this kind of file. 6. Click OK. Repeat the above for .xls files and Excel.exe Hope that helps.

Answer 3

Format your cells to the type Time.



In MS office 2007, this can be done by going to Home tab-> Format menu item -> Format Cells -> Number tab. Then in category select Time. You can select any Type on the right hand side. Make sure you have all the cells selected for doing this (including the cell for results of addition or subtraction).



Then in cell for results you can write any formula, for example - "=A3-A1".



Hope this helps.