Support Board
Date/Time: Mon, 19 Oct 2026 22:40:16 +0000
Post From: Conversion to Non-CLR Spreadsheets
| [2014-08-14 19:20:45] |
| Sawtooth - Posts: 4357 |
|
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. |