Under normal circumstances, the total time is subsequently multiplied by the
hourly rate to calculate the total monies due.

That is why, in my post, I suggested that you format the Column C cells to
Number or General.
That allows the totals to return a dollar amount when multiplied by the
rate.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ronnie Kray" wrote in message
...
=SUM(C1:C2)
this works fine for 2 cells how do i add C1 C2 C3 C4 C5
if all daily hors are 10:00
i need it to show a total of 50:00 hours worked

ps sorry for the lame questions but its 18 years since i last worked on
excell at school
thx ronnie




"T. Valko" wrote:

Try this:

=SUM(C1:C2)

Format as [h]:mm

--
Biff
Microsoft Excel MVP


"Ronnie Kray" wrote in message
...
Thanks Guys that works a treet but no i have a problem working out the
Totla
Hour worked Per Week
mon
A1 07:00 Stasrt
B1 17:30 Finish
C1 10:30 (hours worked With your previous formulars)

Tue
A2 07:00 Start
B2 16:45 Finish
C2 9:45 Hours

So how do i add C1 & C2 to show total hours which should be
20 Hours 15 Mins