They are figured using TEXT, it is the only way that i could get it to figure
elapsed time, if you can point me in a different direction please do so. At
this point any help is greatly appreciated. Thanks again

Lyle

"JE McGimpsey" wrote:

If they were really XL times figured by XL, the SUM() formula would have
worked.

How were they "figured"? If you used the TEXT function, then the values
are Text, not XL times, and SUM() will ignore them.




In article ,
"lylehughey" wrote:

Chip and JE,

Neither of those worked, Chip yours returned with a 00:00 and JE yours
returned 12:00:00AM, remember these are times that have been figured by excel
in a cell, the format that they are in is h:mm (4:10) as an elapsed time
already, i just need to get them added together.