changing time format for a channel from 12 hr to 24 hr

[Jcheese]

I have a Date/Time Channel 04/13/2013 1:00:00:00pm and I want the channel to be 24 hr format for this one channel and not all of my time channels. How could I do that.  So my time would go from 12:59 to 13:00 instead of 12:59 to 1:00.

[Walter_Rick]

Hi Jcheese,

In the general settings of DIAdem you can define the time format. If you delete the parameter "ampm" you get the 24 hour format.

Greetings

Walter

[Jcheese]

Thanks Walter for the reply, The problem is I load another set of data on top of the original group that does not have this issue and I need to keep the date/time in that one unchanged.  I have thought about possibly adding 1 after the 12:00 pm and storing it in the original channel but not sure how I would do that.

[Walter_Rick]

The kind of time display is always  just a question of the way to format it. Internally the time values are counted from zero from year zero and stored in a double value.

Can you provide an example (dataset, layout and/or screen shot) of what exactly you would like to do.

Greetings

Walter

[Jcheese]

The DateTime Channel is store as an example in column 1 in the "book1" and the correctly formated is in Column 2.  It is just a format issue I agree but some some reason my brain can't think striaght on this one.

so the issue is

6/7/2013 12:59:59

6/7/2013  1:00:00

Diadem doesn' like this in graph form because it thinks linear so the datapoint from 1 gets put before 12 instead of in correct time location

[Walter_Rick]

On each place (like REPORT or VIEW) where date/time data are shown you can set an individual time format like "#mm/dd/yyyy hh:nn:ss" or similar.

Typically you set this format for the whole channel (column). But maybe I still don't understand your problem. Perhaps it is a good idea to provide an example.

Greetings

Walter