Time Format

[Anonymous]

Hi All,

I'm wondering how to change the format of my time field ? exempl:

12:12:03

12:12:45

12:13:03

12:13:54

i want to change this time to :

12:12

12:13

???

regards

[Gysbert_Wassenaar]

If it's already a time field then time(MyTime, 'hh:mm') will do. If it's a string you need time(time#(MyTime,'hh:mm:ss'),'hh:mm'). Replace MyTime with the name of your time field.

[Anonymous]

i did the same thing , but i got :

12:12

12:12

12:13

12:13

[Gysbert_Wassenaar]

ah, in that case use time(floor(MyTime,1/1440),'hh:mm')

[vivek_niti · Accepted solution]

Hi,

Try using

time(ceil(num(F1),0.001),'hh:mm')