Thread: how to do this in int x + int (frac x*100)/60 + frac (frac x*100)/
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default 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 With QuoteReply With Quote