Time format problem

[Redwynne]

Hi!!

I need help in formatting the following data.

To explain, when I run a report I get data in the format of:

[number of days][hh:mm:ss.hundred of seconds]

The [number of days] is usually zero as you can see with the sample below.

0 00:03:47.000
0 00:12:39.000
0 00:17:20.000
0 00:26:57.666
0 00:34:32.500
0 00:38:47.333
0 00:47:08.500
0 00:54:57.833
0 00:57:05.750
0 01:01:46.666
0 01:10:09.333
0 01:37:47.000
0 01:43:51.200
0 01:53:36.800
0 02:23:02.000

When I export the data from the reporting program the formatting changes.

For example the first one the list is 0 00:03:47.000

and in the spreadsheet it looks like 0 00:03:47

but if you look in the cell contents its actually 0/01/1900 00:03:47

No matter how I try to format the data I cant seem to get the hundreds of seconds and I get a date instead of a number at the beginning.

Any ideas on how I can format the cells so I get 0 00:03:47.000?

Thanks for your help!!

[robert111]

hh:mm:ss.000