I have had help here stripping a digit off a field with a LEN funciton.
Which is going from HHH:MM:SS to HH:MM:SS. With the LEN statment I insert a
column, the new column holds the LEN statement and coverts correctly however
now I can't sum the times in the group (I'm assuming its because all the
columns are calculated LEN statements. How can I either add the column OR
create a macro to remove the furtherest 0 (which would be HHH to HH)?

thanks