Formatting Time

[#1]

Is there a way to format the hour of the day in a table and/or graph to show 1:00pm, 2:00 pm rather than 13, 14?

Thank you,

Karen

[hector]

Hi, these are the options for your need

• Use time(field,'hh:mm:ss TT'), TT means AM or PM
• Change the value for the variable TimeFormat = 'hh:mm:ss TT', but this is going to change every time field

Hope this will help you

rgds