You are trying to sum text cells, so that is why you get no result.

Either change E2 to =D2-C2 and format as time, or in the totals cell, use

this formula which bypasses the text file, =SUMPRODUCT(D2

26-C2:C26)

--

HTH

RP

(remove nothere from the email address if mailing direct)

"M K Rao" <M K (E-Mail Removed)> wrote in message

news

(E-Mail Removed)...

> I have caliculated the time worked for the day using the formula
=TEXT(D2-C2,

> "hh:mm"") -where D2 is the time work closed and C2 is the time work
begun. I

> got total time worked for the day in hours and minutes. I caliculated like

> this for the whole month. Now here I am facing a big problem totalling all

> the worked hours for the whole month. I used the formula =SUM(E2:E26)

> where E2 is D2-C2 and so on. But no result. I formatted the cell where the

> formula =SUM(E2:E26) as [hh]:mm as I have seen this formatting on these

> pages.But to no use.Can any one can help me how to solve this problem step
by

> step since i am very new to excel. Just I have started learning Excel. Yet
I

> don't know abcd of Excel. I will be very thankful for the help.

> With best wishes to youngers and bestbregards to elders

> M.Koteswara Rao

> From INDIA