=TEXT(D5-C5,"h:mm")

That formula is returning a TEXT string. You should use this formula:

=D5-C5

And format the cell as h:mm

Then, to get the total from a range:

=SUM(.........)

And format that cell as [h]:mm

Biff

"kayti57" wrote in message
...
I am trying to track time spent on jobs and I have my hours totaled using
the
following format: =TEXT(D5-C5,"h:mm")

However, Now I want to total all these numbers and cannot figure out the
format to do that.

Any ideas?