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

[tresB]

Simple formatting should work then. Try like:

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

[swuehl]

You can also set an explicite format on number tab, select time and format 'hh:mm:ss'.