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.

Thanks

Lyle

"Chip Pearson" wrote:

Times are just numbers, between 0 and 1, indicating a portion of
a 24 hour day (0.25 = 6:00, 0.5 = 12:00, 0.75 = 18:00, etc), and
therefore you can simply add them together. E.g.,

=SUM(A1:A10)

Format the result cell with a custom number format of [hh]:mm or
[hh]:mm:ss


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"lylehughey" wrote in
message
...
I am trying to get it to add together using the TEXT function,
and it will
only do it if i select and add each individual cell into the
formula, is
there not an easier way to do this?