Why not just have the calculation in C2, but format it so that it displays as you like? Or if need the text in one and the number in the other, just write the equation again and format it anyway you want...time, decimal, etc.