Support Board

Date/Time: Wed, 27 Nov 2024 10:24:13 +0000

Post From: Conversion to Non-CLR Spreadsheets

[2014-08-14 19:20:45] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
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.