Rounding milliseconds

[adamwadler]

Hi,

I'm using time with millisecond precision. I have some values such as hh:mm:02.345 (2 seconds, 345 milliseconds). Using second() function in excel seems to round this up/down to the nearest second depending on if millisecond part is greater/less than 0.5.

I would like to always round down to the nearest second (e.g 2.99 seconds becomes 2 seconds, not 3). Is there any function or VBA code that can do this cleanly? Or does not have a clean implementation for this granularity?

Thanks in advance for any help!

 

[Colin Legg]

Try this:

=FLOOR(A1,1/24/60/60)

 

[adamwadler]

Perfect! Thanks again.