How to edit time data

[Former Member]

HI I have a number col that stores the time as

80200 this is 8.02am

how to show as 8.02

with AM and PM would be good to have as well.

[Former Member · Accepted solution]

Hi,

Try this formula: cstr({time field},"hh:mm:ss tt")

For example : this display 06:30:23 PM ..you can remove 'tt' in formula PM/AM is not display like that: 06:30:23

Based on your requirement display time with AM/PM as well.

See reference this:

--dj

[Former Member · Accepted solution]

this does work, but in case there is bad data, how to prevent from crashing?

[Former Member · Accepted solution]

Hi,

--> One more point you can display time filed in report then > right click on that time filed > format field > customize > show Time screen (select 'None' option instead of AM/PM) this is more helpful and formatted timezone as you wanted to display..

Bad data in the sense can you provide some examples?

--dj