I need some help resolving a calculation formula and/or display in Excel 2003.

I need to keep track of actual time worked on a project for variuos clients
and total that time.

I enter the start time in column B (display format is hh:mm:ss) and the
finish time in Column C (display format is hh:mm:ss).

Depending in a code entered in column A, the elapsed time is displayed in
either column D, E or F.

I calculate the elapsed time using the formula =(($Cn-$bn)+($Cn<$Bn)) where
n is the relevant row. The result is correctly calculated and is displayed
in the format hh:mm:ss

I wanted to be able to calculate the total time for each Category (Columns
D, E, and F) but using the =SUM($dn:$dx) where n is the starting row and x is
the ending row.

Here is where I come unstuck as the total hours simply do NOT add correctly
if the total hours exceed 24!

I also wanted to sum the totals of Columns D, E, and F but encounter the
same problem.

Can anyone suggest a solution to my problem?

Thanks very much (in anticipation).


D. Bruce
USAOz Services