Hi All,
Appreciate someone can help me for the working shift counting. Please find attchement and below some explanation.
* Per Day 3 shift and shift started (0800hrs ~ 1559hrs / 1600hrs ~2359hrs / 0000Hrs ~ 0759Hrs)
I'm require to set auto count at B5 whereby the Plug / Unplug fall into particular date&time, for example.
01. If Plug 2013/02/04 07:41, unplug 2013/02/04 08:10, the total shift should be "2 SHIFT".
02. If Plug 2013/02/04 07:41, unplug 2013/02/04 16:10, the total shift should be "3 SHIFT".
03. If Plug 2013/02/04 07:41, unplug 2013/02/05 00:10, the total shift should be "4 SHIFT".
04. If Plug 2013/02/04 07:41, unplug 2013/02/06 08:10, the total shift should be "5 SHIFT".
05. If Plug 2013/02/04 08:10, unplug 2013/02/04 08:45, the total shift should be "1 SHIFT". (Problem in attchement)
Rgrds,
Joe
Bookmarks