Hh:mm field


I have a csv I need to import where several columns contain time data in terms of hours and minutes, it can be 10:24, or 78:11 or even 178:02, so it is not ending at 24:00

With these hours I need to to do calculations later on, basically sum and average.

I am struggling to find the correct field type for these data, if I use date/time or timer it converts the data to something strange and if I use simply text I can not do any calculations with it.

Any help is highly appreciated