Hi Guys,

Just wondering if someone could help me with an annoying issue that i'm having at the moment.

Basically, I do a lot of extracting data from a system, which comes of in "excel" format. A lot of the data is time taken to do a job, which comes off such as 14:50 etc, i then want to add these figures together via auto sum. But excel just doesnt pick up the data at all, even when i change the format to [h]:mm.

But the interesting bit is, if i double click to cell as in to edit it, then straight away press enter, it then becomes a normal time cell and can be added, can i make the whole sheet do this automatically? Or i do i have to go through 5000 records clicking and pressing enter?

Please help!!

Many Thanks,

WIll