Support Board
Date/Time: Tue, 26 Nov 2024 20:31:46 +0000
Post From: Using Spreadsheet Time to Calculate Slope
| [2014-06-06 13:33:41] |
| Sawtooth - Posts: 4120 |
|
Here's some info on spreadsheet time formats: http://www.sawtoothtrade.com/tip-4.html Since the spreadsheet study array is in descending order, A3 is a greater value than A4. To get the exact value in seconds between A3 and A4: =(A3-A4)*86400 Or in minutes: =(A3-A4)*1440 Or in hours: =(A3-A4)*24 Date Time Of Last Edit: 2015-08-14 02:02:11
|