Support Board
Date/Time: Sun, 02 Nov 2025 22:59:19 +0000
Post From: Spreadsheet programming question
| [2022-10-25 01:14:56] |
| Sawtooth - Posts: 4285 |
|
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
|