tima format

[Anonymous]

hi,

i have feild like this -141819 (hhmmss)

i want to make it to time like this:

14:18

how can i do it ?

thanks'

yarin.

[jonathandienst]

Hi

This should do it. Expression:

=Time(Time#(myField, 'HHMMSS'), 'HH:MM')

or script:

Time(Time#(myField, 'HHMMSS'), 'HH:MM') As myField,

HTH

Jonathan

[kumarnatarajan]

Hi,

Try below one.

Ex:  Time(Time#(141819,'hhmmss'),'hh:mm')

[MayilVahanan · Accepted solution]

Hi

Try like this

TIme(Time#(fabs(-141819),'hhmmss'),'hh:mm')

or

TIme(Time#(141819,'hhmmss'),'hh:mm')

[sunilkumarqv]

Set TimeFormat='hh:mm:ss';

you want to change the regional settings in OS

[#6]

hi yarin

=Time(Time#(FieldofTime, 'hhmmss'), 'hh:ss')