I have a spreadsheet that is exported from AccuCall Web in Excel format. I need to sum the time of all long distance phone calls (which are all in a single column). When I use the Sum function and specify the range of cells with time, it shows 0:00:00 (I have formatted the cell containing the sum as [h]mm:ss). If I change the formatting of the individual cells in the column to 1:30:55 PM format, the cell still displays 0:01:22 for a one minute and 22 second call, and the sum does not change. However, if I double click on any of those formatted cells in the range and then simply hit escape to make no change, the sum properly adds the 0:01:22 (or whatever) to the total.
Since the column contains hundreds of cells, I am looking for a way to not have to double click on each cell in order for the formatting of that cell to update. Suggestions?
Scott
Since the column contains hundreds of cells, I am looking for a way to not have to double click on each cell in order for the formatting of that cell to update. Suggestions?
Scott
Last edited by a moderator: