How to get the hours,minutes,seconds,frac?

[#1]

Hi All,
Can any one let me know how to get the hours, minutes, seconds, frac from the values like
1.17:2:35.000
122.14:31:11.000[hhh.mm:ss:ff.ttt]

[ecolomer]

hh=hours(val)

mm=minute(val)

ss=second(val)

[#3]

hi try this

min(yourvalue)

second(yourvalue)

hours(yourvalue)

second(yourvalue)

frac(yourvalue)

[tresesco]

Like:

Hour(Timestamp#('122.14:31:11.000' , 'hhh.mm:ss:ff.ttt')) -> Hour

Minute(Timestamp#('122.14:31:11.000' , 'hhh.mm:ss:ff.ttt')) -> Minute

Second(Timestamp#('122.14:31:11.000' , 'hhh.mm:ss:ff.ttt')) -> Second

Frac(Timestamp#('122.14:31:11.000' , 'hhh.mm:ss:ff.ttt')) -> Frac

[#5 · Accepted solution]

Hi All I Got it
TextBetween(Timefield,'','.') as Hour,
TextBetween(Timefield,'.',':') as Minute,
TextBetween(Timefield,':',':') as Second,
TextBetween(Timefield,':','.',2) as Frac,
TextBetween(Timefield,'.','',2) as tt,

Thank you for your Response.