Power query apply formula to mixed data column

Hi   I imported a table of students marks, and the columns have either marks written or 'Absent'. Now I want to create another custom function column with 50% of the marks. But if I input the form...