Thanks again Frank...
I selected a little range using the function with NO color index...
0H:3M
23H:28M
0H:8M
9H:39M
14H:46M
5H:56M
2H:54M
0H:1M
13H:51M
0H:1M
9H:46M
0H:13M
0H:4M
11H:54M
0H:13M
0H:15M
8H:41M
I used....
=sum_pseudo_time(D1:D17)
in cell D18
this is the result I got... "-" ???
102H:-7M
"-" ??? why the minus??
Thanks for all your help... you're really good.
- Larry -
VBA Amateu
--
Message posted from
http://www.ExcelForum.com