A: ### Quick Answer

For Excel 2010, to convert a decimal into a standard time format, enter the formula "=TEXT([desired cell number]/24, "h:mm")" and replace "[desired cell number]" with the correct cell number. This will change the number into a standard hours, minutes and seconds format.

Know MoreTo change the formatting in Excel 2003, first select the cell containing the number. Then click on "Format" and select "Cells" from the drop down menu. In the new window, click on the "Number" tab. In the "Category" box, click on "Time." A number of different formatting options will be displayed. Select the desired option and click "OK."

Learn more about Software- Q:
## How do you subtract in Excel?

A:To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not have a specific SUBTRACT function.

Full Answer >Filed Under: - Q:
## How do you create a tally chart in Excel?

A:To create a tally chart in Excel, go to the File tab in Microsoft Excel. Select New, and then select the Blank Workbook option. If the information is already in a spreadsheet, open this document, and organize the information into columns so that each row is a distinct record.

Full Answer >Filed Under: - Q:
## How do you calculate covariance in Excel?

A:To calculate covariance in Excel, use the covariance function. The syntax of the function is: COVARIANCE.P(array1,array2), where array1 and array2 are the two sets of data for which the covariance is being determined.

Full Answer >Filed Under: - Q:
## How do you create a pivot table in Excel?

A:To create a PivotTable in Excel 2010, click Insert at the top of the worksheet, and select the PivotTable icon on the left. To properly generate a PivotTable, you must first organize your data and then design the layout.

Full Answer >Filed Under: