adding a code to calculate how much time is lost
At work I am building a downtime sheet. The codes we are using in one colum
is SC for sawchange, R for Rocks, N for nails, M for Mecanical, E for Electical and F for flow of production. On the column next to the code column we fill in how much downtime we lost for the day. How can I keep track of how much down time was for each code? I just can't figure out how to seperant the time for the differnent codes? Thank-you for all who can help -- This is what you get |
adding a code to calculate how much time is lost
hi,
I think the =sumif formula would be your best bet. since you are seperating the codes, you would need a sumif for each code. you could put the sumif formulas in a special "summary" column. you could then sum the sumif's. if your codes were in column a and your downtimes were in column b then =sumif(A1:A100,"M",B1:B100) 'M for macanical look up sumif in help for more info. Regards FSt1 "vwghia21" wrote: At work I am building a downtime sheet. The codes we are using in one colum is SC for sawchange, R for Rocks, N for nails, M for Mecanical, E for Electical and F for flow of production. On the column next to the code column we fill in how much downtime we lost for the day. How can I keep track of how much down time was for each code? I just can't figure out how to seperant the time for the differnent codes? Thank-you for all who can help -- This is what you get |
adding a code to calculate how much time is lost
FSt1,
Thank-you FSt1, I have spent a week on this solution and you solved it. Many Thanks -- This is what you get "FSt1" wrote: hi, I think the =sumif formula would be your best bet. since you are seperating the codes, you would need a sumif for each code. you could put the sumif formulas in a special "summary" column. you could then sum the sumif's. if your codes were in column a and your downtimes were in column b then =sumif(A1:A100,"M",B1:B100) 'M for macanical look up sumif in help for more info. Regards FSt1 "vwghia21" wrote: At work I am building a downtime sheet. The codes we are using in one colum is SC for sawchange, R for Rocks, N for nails, M for Mecanical, E for Electical and F for flow of production. On the column next to the code column we fill in how much downtime we lost for the day. How can I keep track of how much down time was for each code? I just can't figure out how to seperant the time for the differnent codes? Thank-you for all who can help -- This is what you get |
adding a code to calculate how much time is lost
Hi
Just to add to the solution posted, you can use a cell reference in place of the "M" in the formula. You could create a list of your downtime codes, maybe on a second sheet in cells A1:F1, by entering SC, R, N etc. Then in A2 enter =SUMIF(Sheet1!$A$1:$A$100,A1,Sheet1!$B$1:$B$100) copy this formula across though cells B2:F2 and you will have a table of your downtimes by reason. -- Regards Roger Govier "vwghia21" wrote in message ... FSt1, Thank-you FSt1, I have spent a week on this solution and you solved it. Many Thanks -- This is what you get "FSt1" wrote: hi, I think the =sumif formula would be your best bet. since you are seperating the codes, you would need a sumif for each code. you could put the sumif formulas in a special "summary" column. you could then sum the sumif's. if your codes were in column a and your downtimes were in column b then =sumif(A1:A100,"M",B1:B100) 'M for macanical look up sumif in help for more info. Regards FSt1 "vwghia21" wrote: At work I am building a downtime sheet. The codes we are using in one colum is SC for sawchange, R for Rocks, N for nails, M for Mecanical, E for Electical and F for flow of production. On the column next to the code column we fill in how much downtime we lost for the day. How can I keep track of how much down time was for each code? I just can't figure out how to seperant the time for the differnent codes? Thank-you for all who can help -- This is what you get |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com