Hi,

After speaking to you via email I understand that you have a file with some time data similar to the following:

COLA
12:23:00
15:45:00
19:27:00
23:59:00
25:00:00
29:30:00

If you import this into DataManager then use a Field organiser and change the field to a Date/time you are using the following format to parse the data:

HH:mm:ss

This results in the following:

COLA
12:23:00
15:45:00
19:27:00
23:59:00
[blank]
[blank]

Because the last two dates are outside of a single day's time range they cannot be parsed.

To include these dates you should create a new field in the Field Organiser block. Inside this field select 'Use formula' and enter the following formula:

TEXTTODATE([Cola], "HH:mm:ss", true)

This will convert the data in COLA into a date, with the 'lenient' option set to true. The 'lenient' option allows Omniscope to handle times outside of the range 00:00 - 23:59.

Now you simply need to change 'Date format (output)' for this new field to:

HH:mm:ss.

The resulting data will be as follows:

12:23:00
15:45:00
19:27:00
23:59:00
01:00:00
05:30:00

Regards

Chris

Useful fix but it is still an issue for those of us in media/advertising agencies as many of the world's Television Audience Measurement Systems work on a 06:00 to 29:59 day - not using 00:00 to 05:59.

Hi,

could you please give us more context on how you will be using your data? Does the fields with the time values need to be converted into a Date format for your usage.
For example if you are using those value in Graph or Bar view, leaving the field as a Text format would meet your requirement better.

Regards.

If you work with values in the range 06:00 to 29:59, where 24:00 upwards is in fact the next day, these will need to be converted into real time values. Omniscope models times and dates as exact moments in time, rather than logical values.

So, you will need to separate out the hour element using formula functions that manipulate the text, and if over 24, subtract 24, and (if it's a date+time field rather than a time-only field), add 1 day. Then put the date back together and convert to a date.

These would then be displayed with 00-23 hour values. If you wanted the original values, you would need two fields - the original text for consultation, and the convert time field for plotting in graphs.

See http://www.visokio.com/kb/functions-guide

Please post back if you need help with this.