View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jgbadingerjr jgbadingerjr is offline
external usenet poster
 
Posts: 14
Default How to break apart a Decimal formatted number?

thanks this seem to work but H2 is not rounding down (29.5000000) it should
reflect jusr 29 I'm going to look up this RoundDown function but if you
understand what is happening and post it here that is fine...I will check
back later.

Thanks for your help!
--
jgbadingerjr


"Gary''s Student" wrote:

=ROUNDDOWN(F2,0)
=60*(F2-G2)
=60*(H2-ROUNDDOWN(H2,0))


In G2, H2, I2
--
Gary''s Student
gsnu200712