Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
Help for a newbie trying to add hours and minutes :) | Excel Discussion (Misc queries) | |||
Can I use Excel to add hours and minutes like keeping a dive log? | Excel Discussion (Misc queries) | |||
excel [HHHHH]:mm add subtract hours mins inc lnegative | Excel Worksheet Functions | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions |