Converting time value stored as text
Hi, I have a column of time value in the format of 'HH : MM : SS' - it is currently stored as text, I want to be able to run some calculation such as looking at the sum, or average of this column. How do I do that? When I aggregate the data, I'd like it to still output as 'HH : MM : SS' on the graph