in my excel file there is a column of times in the format hh:mm:ss.
I want to convert it to decimal value (i.e. 02:15:30 will be 135.5 min.).
the problem is that every value starts end ends with spaces, and because of
that I can't use the functions hour(),minute(),second().
I can delete the spaces one by one, but it's a large file and a lot of work.
how can I delete the spaces ??
thanks a lot
--
abugoli