Support Board
Date/Time: Thu, 26 Jun 2025 09:29:56 +0000
Post From: Spreadsheet programming question - FRACTIME
| [2021-12-04 20:07:01] |
| User183724 - Posts: 194 |
|
I have a 5 minute chart with a spreadsheet study. In column AN, I have this formula =FRACTIME(A3)-FRACTIME(A4). I'm looking for the difference between the last two FRACTIMES. Im getting the following results: 0.00347222222222221 row 3 0.00347222222222221 row 4 0.003472222210648135 <========= ... 0.003472222233796285 <========= 0.00347222222222221 0.00347222222222221 0.003472222222222321 <========= 0.00347222222222221 0.00347222222222221 0.00347222222222221 0.00347222222222221 0.003472222210648135 <========= 0.003472222233796285 <========= 0.00347222222222221 0.00347222222222221 0.003472222222222321 <========= 0.00347222222222221 0.00347222222222221 appears to me to be the 'correct' answer and those 'hiccups' are where the sheet updates. I understand they are double float numbers and will be slightly different based on updates. Could someone with better math skills please explain just how long the updates take and maybe a little on the time keeping in general. Ive read all I can find on time keeping including the following but cant quite make sense of it. Spreadsheet Functions: Serial DateTime Values Spreadsheet Example Formulas and Usage thx tim |