Hello Experts. I need your help regarding working with the Status Bar – Average function.
I have a spreadsheet created from a system export file. The column titled time is formatted [h]:mm. I can use the Excel Status Bar and view the cell count in the column but not the average or sum. See attached sample file. I’ve tried reformatting the original cells but doesn’t solve the problem. What does change things is when I Edit each sell and simply exit the cell – the the average function works.
Any thoughts about how to work with data sheet which comes in each day?