Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. * * |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|