Login Page - Create Account

Support Board


Date/Time: Sun, 05 May 2024 11:26:49 +0000



Post From: Using Spreadsheet Time to Calculate Slope

[2014-06-06 13:33:41]
Sawtooth - Posts: 3993
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