Time format issue

[vanderson009]

On bar chart I have Time Field on Y axis, and its shown as like

12:01:30 AM

12:00:30 AM

12:00:00 AM

but I want to convert AM into 24 hr but I could not able to do it.

Can some please help me to convert it into 24 hr time format.

Thanks,

Villyee

[jonathandienst]

   Time(Time#('12:01:30 AM', 'hh:mm:ss tt'), 'hh:mm:ss')

Or to use with [Time] field:

   Time(Time#([Time], 'hh:mm:ss tt'), 'hh:mm:ss')

[jonathandienst]

If Time is already a proper QV time field and you just want to format it to 24hr, you don't need the Time#() part:

   Time([Time], 'hh:mm:ss')

[arulsettu]

may be this

Timestamp(Timestamp#('12:01:30 AM','hh:mm:ss TT'),'hh:mm:ss')

[vanderson009]

Hi Jonathan,

Thanks for you reply, In database that values in number format, how can I handle it then.

Regards,

Villyee

[MindaugasBacius]

If the Time is loaded as the digit than try this formula:

Time(Time, 'hh:mm:ss').

[sunny_talwar]

Can you show few datapoints just to make sure we understand how time looks? Is it in decimals like 0.2465214 or is it an integer?

[Kushal_Chawda]

if it is in number then what that number represents? is it days ? is it hour ? is it seconds?

[vanderson009]

When I am doing it in straight table, then getting 24 hr time format, however straight table convert into bar chart then y-axis showing 12 hr format.

[vanderson009]

Hi Sunny,

Is it in decimal..