Unable to resolve the name data.Time.

My colume has Time in this formart HH:MM:SS, how do i covert this column to numerical value?

[Rik]

What have you tried? And are you working with a table or a cell?

[Cris LaPierre]

The title and question seem unrelated.

What numerical value are you wanting to turn it into? Is there a reason why you can't keep it a datetime?

[Paulus Tjakula]

I want to convert it to double datatype because I want to use the dataset for curve fitting

Answer 1

[Walter Roberson]

duration() the column. seconds() to get a numeric value.