I have a column in my data that is in the format "D:H:MM". Trying to get the average in a pivottable and I keep getting the error #DIV/0!. Any ideas?

Thanks