If I understand you, you want to strip off any hours > 100. If that's
the case, one way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(MOD(G1:G10,100/24))


In article <72CE2CB2-2216-4609-B098-4EFCA2615CB1@microsoft.com>,
"tri_p" <trip@discussions.microsoft.com> wrote:

> 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