Support Board
Date/Time: Thu, 11 Dec 2025 21:59:56 +0000
Post From: Conversion to Non-CLR Spreadsheets
| [2014-08-14 19:20:45] |
| Sawtooth - Posts: 4298 |
|
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. |