Support Board
Date/Time: Wed, 19 Mar 2025 17:04:17 +0000
Spreadsheet programming question
View Count: 368
| [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 |
| [2022-10-25 01:14:56] |
| Sawtooth - Posts: 4186 |
|
Try this: =(J$41*86400)-(A$3*86400) or =(J$41-A$3)*86400 Either of these will return the number of seconds difference between the two. J41 and A3 use SerialDateTime format, where the date is an integer, and the time is a decimal value starting at midnight. If you want to convert a SerialDateTime to seconds, multiply by 86400 (the number of seconds in 24 hours) If you want to convert from seconds to SerialDateTime, divide by 86400. Date Time Of Last Edit: 2022-10-25 01:19:36
|
To post a message in this thread, you need to log in with your Sierra Chart account: