If your data is always like that and you just want the hours, I would use formula with Word or Words and then just calculate the values together. One example below:
If your data is always like that and you just want the hours, I would use formula with Word or Words and then just calculate the values together. One example below: