topic Time format including AM/PM in QlikView

Time format including AM/PM

mellerbeck — Wed, 24 Aug 2011 17:48:40 GMT

I only see in the help Time(HH:MM:SS)

Anyone know how?

Wed, 24 Aug 2011 19:28:46 GMT

Try this:

h:mm:ss tt (if you want seconds)

h:mm tt (if you do not want seconds)

Sokkorn — Thu, 25 Aug 2011 00:16:18 GMT

Hi,

I have two solution:

1. On Chart

Right Click on Chart --> Properites --> Select Number tab --> Select on Expression --> Check on Time for number formate setting.

2. Use function:

TIME(TimeField,'h:mm:ss TT')

Regards,

Sokkorn