Microsoft Office Forums - View Single Post - [Solved] Date and time calcs excluding non-working hours

Thread: [Solved] Date and time calcs excluding non-working hours

View Single Post

Old

01-26-2011, 08:50 AM

mrsatchmo

mrsatchmo is offline

mrsatchmo uses Windows Vista

Windows Vista mrsatchmo uses Office 2003

mrsatchmo uses Office 2003

Office 2003

Novice

The original poster

Join Date: Jan 2011

Posts: 2

mrsatchmo is on a distinguished road

Default

e.g.
2 hour job starting Thursday 27th Jan 2011 @ 1am would finish Monday 31st Jan 2011 @ 7am. (Production stops at 2am Friday morning after 1 hour of work completed, resumes at 6am the following Monday to carry out 2nd hour of work finishing at 7am.)

Hope this makes sense!!!

Last edited by mrsatchmo; 01-26-2011 at 10:51 AM.

Reply With Quote