Counter on Excel that counts up every X amount of minutes

Good morning All,

Just to begin many thanks in advance for anyone who can help me out .
I am not the worst on Excel, but i have an idea and not really sure to even begin on how to get it to work due to all the variables.

Basically i need to create a screen showing live possible parts (9 Models) produced in a shift (3 Shifts, Earlies - Lates - Nights).

So i need a counter that resets to 0 when the new shift starts and then counts up 1 every time dependent on the model being run (Different cycle times).

I have so far got the shifts/times and also the models and cycle times in a table but i just need some help on how to pull it together.

in same instance if what im trying to achieve is not possible via excel, id be grateful if you can let me know.

Kind regards All.

Dale

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.