Time Formatting

[manisha_uit]

Hi All,

I have a field ActualTime which is in "hh:mm:ss TT" format. In the script, I am changing it to "hh:mm TT" format using

Time(field, 'hh:mm TT')

Now, I am trying to plot ActualTime required to finish the task. The problem is i am unable to format the Y-axis in "hh:mm TT" format. However, when I hover over my mouse, i get the correct format "hh:mm TT"

Please refer image for more details

Thanks,

Manisha

[giakoum]

Time is a formatting function. It does not change the feild type. Try using Time# instead

[jonathandienst]

Hi

Go to Document Properties | Number, and set the time format for the field here.

HTH

Jonathan

[manisha_uit]

Hi Jonathan, loannis

I tried both the options suggested by you but the result is not as expected

Thanks,

Manisha

[manisha_uit · Accepted solution]

Got the solution finally. I changed the TimeFormat variable to the desired format and it worked!