Support Board
Date/Time: Wed, 19 Mar 2025 17:47:40 +0000
Post From: Spreadsheet programming question
| [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
|