Column with time data (in Text) gives error when converting to time

[efeurich]

Hi Community,

I have a Text column with time text in it like: 345:04:12 - 345 hours; 04 minutes; 12 seconds.

But when I try to change the type to time it generates an error, obviously. 

I need to calculate with this column to determine when some action where triggered or done by people.

Is there another datatype then time to do the calculation with?

[FreemanZ]

if you are going to compare with other date/time, you would need to convert it to the same data type, probably with some code.