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
|