Support Board
Date/Time: Wed, 19 Mar 2025 18:04:30 +0000
Post From: Spreadsheet programming question
| [2022-10-24 21:10:19] |
| User183724 - Posts: 194 |
|
im trying to find the difference in time between A3 and J41 and understand the results...that last part is what i'm having trouble with im referencing this website showing examples of how to convert time used by spreadsheets Spreadsheet Example Formulas and Usage I attempted to convert the time in J41 and A3 to seconds and subtract the results =(J$41/86400)-(A$3/86400) on a 5 minute chart, i'm expecting a number between 0 and 300 however this is a typical result 0.00000004010470278092981 I don't understand the results. any assistance appreciated |