3
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?
1The short answer is "no" if you're committed to using only worksheet functions. However, if you're open to using VBA, a very simple macro can do this. – Excellll – 2011-09-28T20:00:31.063