ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   adding a code to calculate how much time is lost (https://www.excelbanter.com/excel-discussion-misc-queries/108635-adding-code-calculate-how-much-time-lost.html)

vwghia21

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

FSt1

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


vwghia21

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


Roger Govier

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