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

  • Thread starter Thread starter melz
  • Start date Start date
M

melz

how to do this in = int x + int (frac x*100)/60 + frac (frac x*100)/36
can someone help me.
 
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
 
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
 
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.
 
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
 
Back
Top