Time format export data from hours to decimal

[Pmorg73]

I have an interesting query

I am working in time and invoice management web site called workflow max. To get data from the web site I export reports in csv format.

For small time entries the csv exports in a hh:mm format. But for the big ones in the image it is [h]:mm:ss. (image is a filtered view only)

This is happening when the sum of entries invoiced is greater than 24 hours. In the image there is a value of 300:48:00 and when I interogate the invoice that is 300 hours 48 mins.

Further complication, but should change any solution, is that I have an historic csv table up to 2020 and then append a 2020 csv from sharepoint so that the data will continue to grow and also reduce reporting out time from the source.

What I have been doing is creating a new column for decimal hours

I do know that to convert the hh:mm format to decimal in Power BI using csv I need "24 * [time]". Also if it is in xlsx format I need "24 * [time] - 24" to get a created column for decimal time. And decimal time will help with visuals and measures.

Question: What do I need to do in this case where I have a column with two time formats in the csv to get a single decimal time column?