Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
i did the same thing , but i got :
12:12
12:12
12:13
12:13
ah, in that case use time(floor(MyTime,1/1440),'hh:mm')
Hi,
Try using
time(ceil(num(F1),0.001),'hh:mm')