Saturday, July 30, 2011

ROUNDOWN excel function - formula to remove the timestamp in an excel cell

This is in relation to the post on http://exceltutorials.tumblr.com/ entitled Formula to remove TIMESTAMPS in excel. The excel tutorial tells how to use the INT function to remove the time in a cell that contains both date and time. That tutorial works but there is also another way to achieve the same result.

As implied in the said article, the date is the whole number and the time is the decimal. ROUND DOWN function can be used in the same manner as the INT one. But unlike the latter, you have to specify the number of decimal figures to be left.  The syntax for the RoundDown function is:
RoundDown( number, num_digits )
number is the number to round down (which refers to the cell reference)
num_digits is the number of decimals to round the number to

So if cell A1 is  7/31/2011 1:26 or 40755.06 if in number format, the formula to remove the decimal figures/timestamp is =rounddown(A1,0) . By using 0, you're telling excel that there should not be any decimal.

This is just my first. There are more easy-to-follow excel tutorials to come.

This blog is listed in linked words.com under Microsoft Excel