I have several columns of data in an Excel 2010 worksheet that are values in minutes and I want to convert them to hours and minutes (the data source will only generate an Excel workbook using minutes).
How can I convert these values in place to a text string that is hours and minutes.
For example, if I have a cell F1
containing a value 300
and drop this formula into into the same cell I get a circular reference error:
=INT(F1/60)&" h "&MOD(F1,60)&" m"
I could hide the cells containing the raw values and have a second column that has the formula that does the conversion, but it means an awkward extra step for five long columns of numbers.
Is there a way to do this without creating extra cells to hold the calculated value?