Support Board
Date/Time: Tue, 26 Nov 2024 20:25:31 +0000
Post From: Using Spreadsheet Time to Calculate Slope
| [2014-06-06 07:41:58] |
| djcurcio - Posts: 236 |
|
I want to calculate the slope of price changes in a spreadsheet. This requires calculating the difference between the two times - for example A4-A3. But I cant seem to get A4-A3 to work properly - all I get is 0.00 Setting the cell format to time does not help. I assume I must somehow convert the values in A to seconds and then do the subtraction. And then convert the subtraction result back to decimal minutes - ie 121.33 minutes - no hours to get the slope in minutes. Does anyone know how to do this in the spreadsheet? Thanks |