have a 4000+ row flat file that has a event duration column for each event, the data is:

MINUTES

0:10 (this is 10 sec)

0:46 (46 sec)

1:26 (1 min 26 sec)

1:52 (1 min 52 sec)

1:48:11 (1 hour 48 min 11 sec)

38:02:00 (etc etc etc)

simply, i need to total this column. problem is, i can't seem to find a way that gives accurate results.

the total should be 39:54:25 but a sum for example returns 20:04:11. excel interprets 10 sec as 10 min.

if i sum

1:48:11

38:02:00

it returns 39:50:11 which is correct.

i did try to search existing posts for solution and while this is probably answered i just couldn't find.

thanks in advance for any help!

This message was edited by muster101 on 2002-11-08 11:01