MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert 11.5 to 11 Minutes and 30 Seconds


May 20, 2002 - by Juan Pablo Gonzalez

Gregory asks:

If I have 11.5 in a cell how do I get this converted to 11 minutes and 30 seconds in another cell?

Use this formula

=A1/(24*60)

Where A1 houses the 11.5. You may need to format this cell as mm:ss