Q:

How do you convert a decimal to time in Excel?

A:

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.

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

Related Questions

  • Q:

    How do you create a schedule in Excel?

    A:

    Free schedule templates are available for download from Microsoft's official website to begin creating schedules in Excel. Ensure the template is compatible with the computer's current version of Windows before performing the download.

    Full Answer >
    Filed Under:
  • Q:

    How do you merge cells in Excel?

    A:

    To merge cells in Excel, simply highlight the cells you want to merge, right-click, and select Format Cells. Next, select the Alignment tab, and check the Merge Cells box. The process should take less than one minute to complete.

    Full Answer >
    Filed Under:
  • Q:

    How do you unhide rows in Excel?

    A:

    To unhide rows in Excel, open the Excel worksheet, select the first hidden row on the worksheet, navigate to the Home tab, select Format, move the mouse pointer to Hide & Unhide, and press Unhide Rows. You can also unhide a row by changing the size of the cell.

    Full Answer >
    Filed Under:
  • Q:

    How do you find duplicates in Excel?

    A:

    To find duplicates in Excel, select the data that needs to be searched, click on Conditional Formatting from the Home tab, create a new rule, and then format the rule for duplicate values. Select a format for the duplicate cells, and click OK to run the search.

    Full Answer >
    Filed Under:

Explore