Excel pivot table from external SP List - Problem with average duration #DIV/0!

I have a SP list that I use as the data source for a PowerApp. For reporting, I have an Excel spreadsheet in OneDrive linked to that SP List. In that spreadsheet, I build Pivot tables and charts for reporting purposes. All of that works. Here is my problem for which I need help - this is blocking me from moving forward on a critical project:

-In the SP list, there is a duration calculation column based on two dates in other columns. That column properly sends over to the Excel spreadsheet as a General column. There are no blanks, but there are some zeroes. (I've tried making in numeric as well.)
-In one of my Pivot tables, I want to show the average duration for the records in a set of areas.
-That Pivot table results in the #DIV/0! error on all rows (a row for each of the set of areas, and a grand total)

I have looked and looked and set most every setting I can find, and nothing makes this work. I've tried deleting and recreating after refreshing multiple times.

I somehow suspect that this has something with the data being pulled NOT being what I think is being pulled. I've tried filtering out parts of the data set that could be blank. The zeroes in the duration column need to stay because the duration was indeed 0 days. Plus that would be in the numerator of the Average calculation, not the denominator, so that can't be it.

Can anyone help? Thank you so much!!!!

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Actually I was able to recreate my problem in a small simple unlinked spreadsheet! Attached...

As far as I can see, the data under DurationToSELeaedr seems to be text instead of real numbers ( it is left aligned) if you have not aligned the data manually.

Try selecting the data Click the Data tab - Text to columns, and Finish. If all is well the contents will now right-align showing they are numbers.
DO NOT try to format as numbers, it will not work

That fixed it! I so appreciate your help! I had tried everything but that, but I had no idea that Text to Columns would do this fix. Is there a good training somewhere that I could learn about this kind of thing? I am fully self-taught in Excel, so I know there are gaps in my knowledge that could be solved.

Thank you!!!

Most welcome
One way of training is trying to help on this forum and reading the solutions proposed by our members and trying to understand how the functions work
If your question is solved please click "thread solved" in the "Thread tools" drop-down