Q:

How do you convert a decimal to time in Excel?

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.

Continue Reading

Full Answer

To 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

Related Questions

  • Q:

    How do you create formulas in Excel?

    A:

    You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, subtract, multiply or divide cell values are entered directly in your worksheet, while more complex formulas are initiated in the Excel formula dialogue box.

    Full Answer >
    Filed Under:
  • Q:

    How do you merge columns in Excel?

    A:

    To merge columns in Microsoft Excel, utilize the CONCATENATE function, and create a merging formula. Add the designations of the cells that contain the desired data to the formula, and copy the formula to other cells in the new column until the content of the original columns becomes fully merged.

    Full Answer >
    Filed Under:
  • Q:

    How do you create income templates in Excel?

    A:

    Use the built-in formula calculations in Excel to help calculate totals. Creating a column of totals allows users to see real-time totals as information is added and updated.

    Full Answer >
    Filed Under:
  • Q:

    How do you subtract dates in excel?

    A:

    To subtract dates in Excel, simply enter the following formula: "=A3-A2", assuming that cells A3 and A2 contain the dates that need to be subtracted. This will output the difference between the two dates, expressed in days.

    Full Answer >
    Filed Under:

Explore