I need to convert data from a system into seconds. It comes in standard hh:mm:ss format. If converted to text format it gives a very odd decimal figure. I have also tried setting up 3 columns, one to extract hours, one for min and one for seconds, using left, mid and right sums. This did not work at all though. Please help me - this is quite urgent!!!