Remove Seconds from hh:mm:ss

[prees959]

Hi,

I am importing data from a csv file which has some time fields eg

08:00:00

Is there a simple way to remove the ss portion of the time field ?

Many thanks,

Phil

[Chanty4u]

try this

Time#(Text(Time(Frac(UrFiled), 'hh:mm:ss')), 'hh:mm') as END_TM

[YoussefBelloum]

Hi,

try this:

=Time(Time#(Field,'hh:mm:ss'),'hh:mm')

[chinnuchinni]

You can use below script:

Time(fieldname,'hh:mm')

[prees959]

Hi,  thanks for your replies - unfortunately after trying each solution I am still getting hh:mm:ss

[YoussefBelloum]

So try to attach some line on an excel file from your original column

[tresesco · Accepted solution]

Try first truncating the seconds from your timestamps first using floor() and then format it using time(), like:

=time(floor(timeField, 1/24/60),'hh:mm')

[prees959]

thank you !

[Anonymous]

here we go:

time#(text(time(floor(TIMESTAMP, 1/24/60),'hh:mm')),'hh:mm') as Time

this will create 1440 unique values, for the time field hh:mm, the numerical value will have no ss in it.

sunny regards