Handling Excel Formulas
Posted: Mon Apr 17, 2017 8:23 am
I have a GO Anywhere MFT Project that produces an Excel spreadsheet. Several of the columns contain dates/times of events. Included in the spreadsheet are additional columns containing formulas written to calculate the differences between various dates/times contained in the other columns.
However, when the resulting spreadsheet is opened, the columns containing the formulas show only the text formulas; the desired calculated values are not displayed. I have to edit the first formula of each column and accept the edit; after that the calculated value shows. Then I double-click the lower-right corner of the cell, which forces the calculations for the remainder of the column. Once the values show, I have to change the column format to hh:mm.
I want to change my project to:
However, when the resulting spreadsheet is opened, the columns containing the formulas show only the text formulas; the desired calculated values are not displayed. I have to edit the first formula of each column and accept the edit; after that the calculated value shows. Then I double-click the lower-right corner of the cell, which forces the calculations for the remainder of the column. Once the values show, I have to change the column format to hh:mm.
I want to change my project to:
- Force the formulas to calculate when the spreadsheet is composed
Format the time difference columns to hh:mm