Support Board

Date/Time: Sun, 05 May 2024 09:25:17 +0000

Post From: Using Spreadsheet Time to Calculate Slope

[2014-06-06 07:41:58] Link To Thread - Link To Post [Go To First Post]
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