Hi,
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