Open an Excel document containing a section with time data written in "hh:mm" format, such as "12:30." Click on an open cell off to the side of the first entry in the existing data.

If you've already entered time into a cell, you can easily reformat it to include hours, minutes and seconds using the Format Cells dialog. Insert Time Formula Select the cell you want to convert ...