Support Board
Date/Time: Tue, 24 Mar 2026 03:44:29 +0000
Post From: FRACTIME and TIME issue or problem in spreadsheets?
| [2025-04-28 01:16:15] |
| Sawtooth - Posts: 4321 |
|
You are seeing floating point imprecision. Round down the FRACTIME to a 1 second multiple using the FLOOR function: This will produce TRUE: =FLOOR(FRACTIME(A3),1/86400)=TIME(13,57,00) |