If you are just looking to get rid of the numbers after the decimal point, using the INT function with your RAND function should do the trick. Open a new Microsoft Excel 2010 spreadsheet.

For example, if cell A1 contains 41 minutes and cell B1 contains 25 seconds, type "=A1/60 + B1/3600" into an empty worksheet cell and press "Enter." Excel should display "0.690278" as the decimal ...