Daily tips for using Microsoft Excel.

Monday, May 20, 2002

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