Time Format of cell does not update until I double click on cell.

[scott0728]

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

 

[linkstatic]

You are great man schielrn !

I am not sure if you will get this reply or not, but i just wanted to let you know you saved a lot of time for me! the date was not updating in a huuugggeeee excel file. made this account just to thank you!!!

 

[sanjid44]

=> You must need to convert text format in Target cells
=> If A2 is your target cell then Use This formula right side of the cell (=""&A2)
=> After you get your desire result then drag the whole formula
=> Then copy the formula cells and Paste it in A column as value paste.
=> That's It.
Note: In formula Don't use () , If you want to use date format then use text formula , like =""&Text(A2,"dd-mm-yyyy")

 

[BlackWeezle]

Welcome to the Board!

Set the column to time and then select all the cells in that column. Go to Data-->Text To Columns and press finish. That should get them all in one swoop.

Hope that helps.

Thank you!!! I had never even heard of that feature. You just saved me a LOT of work.