Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 19 May 2024 06:52:33 +0000

How to Post a Message for Support

Post From: Conversion to Non-CLR Spreadsheets

[2014-08-14 19:20:45]
[Go To First Post]
Sawtooth - Posts: 4000
This is what I use to remove floating point inaccuracies of the SerialDateTime:
=MROUND(A3,1/86400)

This will round the SerialDateTime to the second.

MROUND is not listed in the non-CLR functions, but it works in the non-CLR spreadsheet.