While on client site recently a query was raised regarding using the AutoSum function in Excel for the exported Resource Availability view, this didn’t work due to the hours containing an h. For the AutoSum functionality to work only numeric characters can be in the range. There is a very quick and simple method to remove the h.
Export to Excel:
As you can see the hours contain the digits as well as h, to remove h just use find and replace, typing h in the find what field and leave the replace with field empty. Firstly select the dataset / range as below:
Now press Ctrl + H and enter h in the find what field and leave the replace with field empty:
Click Replace All and the h will be removed:
Any calculations will now work including AutoSum: