Forum Discussion
Column with time data (in Text) gives error when converting to time
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?
1 Reply
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.
