Thankyou Ron for taking time to explain.

Cheers

-----Original Message-----
On Tue, 30 Nov 2004 21:39:51 -0800, "Steved"
wrote:

Hello Ron From Steved

Please is it possible using your formula to get

12.20 from 3.17 will leave 2.57

thankyou.

Yes, it is. If you make the assumption that A2 is ALWAYS
going to represent a
later time than A1, then you can modify the formulas by
substituting for A2 the
expression: A2+12*(A1A2).

However, it might be simpler to use a 24 hr clock; such
as 15.17 in your
example. This would then allow you to span times across
midnight.

In any event, to answer your question, and assuming the
two times represent
times that are on the same day:

=dollarfr(dollarde(A2+12*(A1A2),60)-dollarde(A1,60),60)

or

=INT(INT(A2+12*(A1A2))-INT(A1)+(MOD(A2+12*(A1A2),1)-
MOD(A1,1))*100/60)+MOD(INT(A2+12*(A1A2))-INT(A1)+
(MOD(A2+12*(A1A2),1)-MOD(A1,1))*100/60,1)*60/100


--ron
.