Production Time Calculator

[k30m]

HI,

I'm trying to calculate touch time in production with start & end date/times that take the working day into account and the weekend. The working day is 06:00 (L2) - 16:30 (L3) and its a Mon-Thursday working week. Fri, Sat, Sun should all be counted as the weekend.

=(NETWORKDAYS.INTL(C2,D2,"0000111")*(L$3-L$2)+MOD(D2,3)-MOD(C2,3))

I was trying to use the above formula but its giving me values which are wrong as I've counted the touch time manually and its not working. I obviously don't want to manually count hundreds of jobs so please can somebody help!!

Much appreciated

EDIT: I should also add I'm so incompetent in excel so excuse my ignorance if I've gone horribly wrong on my formula. thanks

 

[Drrellik]

Hello and welcome to the board,

dealing with time can be difficult. if you are able to there is an add in with instructions that will allow you to post your work where others can help without having to re-create your data.
the link is blow and called XL2BB

 

[k30m]

Im ashamed to say I've used Skynets baby and got AI to solve it.

**** these machines. Long live humanity

 

[Fluff]

In future please do not mark a post as the solution, when it does not contain one. Thanks

 

[Drrellik]

K30m, I'm glad you got it working and please come back to the board in the future, don't let Fluff scare you off.... lol everyone here helps for free and hopefully learns along the way