This should do the trick:
to_time( to_string( "<float_time_field>" ), 'hmmss.z' )
Since Shapefiles do not support time
data types (there is date
, but that cannot work without a date...), an easy fix for the above would be to write a string representation of your time:
format_date( to_time( to_string( "<float_time_field>" ), 'hmmss.z' ), 'hh:mm:ss:z' )
Remove :z
to not include milliseconds.
While you could achieve the same results with plain regexp logic, using the time
detour is somewhat more convenient.