convert into Double + (String Date) into Double + String

[userid128223]

i have a field like below. how can i convert it into Double + String format.

field = hh:mm:ss

thx

[rwunderlich · Accepted solution]

Time(Time#(field, 'hh:mm:ss'))

This will create a Dual that will have both a numeric format (fraction of a day) and string display format.

-Rob