how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
 

how to do this in = int x + int (frac x*100)/60 + frac (frac x*100)/36
can someone help me.

how to do this in int x + int (frac x*100)/60 + frac (fracx*100)/
 

I don't know the function FRAC but whatever it is the syntax should
be:

=INT(A2)+INT(FRAC(A2*100)/60)+FRAC(FRAC(A2*100))/36

Reasoning: You choose one cell to hold your variable x, say A2. Thus
your formula refers to A2 wherever there is an x.

I don;t know what you mean exactly and this determines the
parentheses. For example, in your second term:

int (frac x*100)/60

If you mean that you divide the result of INT with 60 then the
expression is:

INT(FRAC(A2*100))/60

If you want to divide frac x*100 with 60 and then take the integer
part then you use the variant above:

INT(FRAC(A2*100)/60)

HTH
Kostis Vezerides

On Nov 22, 2:44*pm, melz wrote:
*how to do this in * *= int x + int (frac x*100)/60 + frac (frac x*100)/36
can someone help me. * *

how to do this in int x + int (frac x*100)/60 + frac (fracx*100)/
 

Hello,

=INT(A1)+INT(MOD(A1,1)*100)/60+MOD(MOD(A1,1)*100,1)/36

Converts a number of format hh.mmss into decimal, for example 02.3030
results in 2.5 (two and a half hours).

Regards,
Bernd

how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
 

Can you give us a description what this formula is supposed to be
calculating? Also, a couple of examples showing values of X and what the
result of the formula should be for them would help.

--
Rick (MVP - Excel)


"melz" wrote in message
...
how to do this in = int x + int (frac x*100)/60 + frac (frac x*100)/36
can someone help me.

how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
 

Hi,

Here is a shorter formula to do the same thing:

=TRUNC(DOLLARDE(A1,60),2)+100*MOD(A1,0.01)/36

Hope this helps,

Shane Devenshire

"melz" wrote:

how to do this in = int x + int (frac x*100)/60 + frac (frac x*100)/36
can someone help me.