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.

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.

Put in as, in A3: =(A2-A1)*24*60
Format A3 as general or number
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tony" wrote in message
...
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.

Excellent, Thank you.

"Max" wrote:

Put in as, in A3: =(A2-A1)*24*60
Format A3 as general or number
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tony" wrote in message
...
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.

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tony" wrote in message
...
Excellent, Thank you.