Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is a cell formatted as a zip code is showing up as a decimal? | Excel Discussion (Misc queries) | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
number keep being formatted as date | New Users to Excel | |||
How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions |