1) Sum based on time. 2) average per day formula

[pmw19800]

Hello All

the formula in F isnt working. i dont understand why ????

1)
Data is on the MFG tab
Colum D = sum everything that was built between the hours 06:00 - 1400

Colum E = sum everything that was built between the hours 14:01 - 22:00

Colum F = sum everything that was built between the hours 22:01 - 05:59


2)
Colum G = Average per day (total parts built / days worked)
Colum H = Average per hour (average per / number of housrs per shift)

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[pmw19800]

whoops

please see attachment

[KOKOSEK]

23:34 is later than 22:00 and is not earlier than 06:00 (is later than 06:00)
Try:

Please Login or Register  to view this content.

[Bo_Ry]

Or
F3
=SUM(SUMIFS(MFG!$E:$E,MFG!$A:$A,$A3,MFG!$C:$C,{">=22:00","<06:00"}))

E3 should be
=SUMIFS(MFG!$E:$E,MFG!$A:$A,$A3,MFG!$C:$C,">=14:00",MFG!$C:$C,"<22:00")

>=14:01 if will not sum 14:00:xx