Support Board
Date/Time: Fri, 09 May 2025 12:33:01 +0000
Post From: Conversion to Non-CLR Spreadsheets
| [2014-08-14 19:20:45] |
| Sawtooth - Posts: 4212 |
|
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. |