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.

Conversion From Minutes & Seconds to a Decimal in Excel. Although the process is hidden from view, Microsoft Excel handles dates and times in the same way as it handles the numbers in an ordinary ...