This is associated: paste this formula anywhere on a spreadsheet and in cell B12 (for instance) write 1230, the cell with the formula now has a value of 12:30 if formatted as time. (0.520833333333333 in reality)
It just saves the bother of writing colons::::::::::::::
=IF(B12>1,TIME(+ROUNDDOWN(B12/100,0),(+B12-(ROUNDDOWN(B12/100,0)*100)),0)," ")
Found it on the web. Handy when you have to write hours & minutes in a lot.