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.