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