Change the format of the cell with the formula in it to [m]. You can do this
by going to Format | Cells | Number. Choose Custom and type [m] in the line
provided
--
tj
"Tony" wrote:
I searched and found a question just like mine but the answer did not work
for me.
here is waht I have: A1 21:05 A2 22:10 A3 =A2-A1 result 1:05 I want to
convert the 1 hout and 5 minutes to 65 minutes. Thank you.
|