View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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.