Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I wish to be able to sum the downtime incurred on shift
for each product. I can do this if we only manufacture the particular product once per shift. What I would like is to sum the downtime incurred between a particular time. e.g Driwall 22:00 - 23:00 Hardwall 23:00 - 01:00 Driwall 01:00 - 05:00 In between these times there may be some downtime so I want to know the actual time run on each product each time Hope this makes sense Pete |
#2
![]() |
|||
|
|||
![]()
Hi Pete
need more details - where/how is your downtime listed? ... Cheers JulieD "Pete" wrote in message ... I wish to be able to sum the downtime incurred on shift for each product. I can do this if we only manufacture the particular product once per shift. What I would like is to sum the downtime incurred between a particular time. e.g Driwall 22:00 - 23:00 Hardwall 23:00 - 01:00 Driwall 01:00 - 05:00 In between these times there may be some downtime so I want to know the actual time run on each product each time Hope this makes sense Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions | |||
Sumproduct - multiple criteria in Column A | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |