how to add hours and minutes in excel
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 |
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:D26-C2:C26) -- HTH RP (remove nothere from the email address if mailing direct) "M K Rao" <M K wrote in message ... 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 |
"M K Rao" wrote: 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 Mr JE McGimpsey and Mr Bob Phillips Many Many Thanks to both of you for your help in solving my problem.By following your advices I solved my problem.Onceagain I thank both of you. With best regards M K Rao |
All times are GMT +1. The time now is 05:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com