+ Reply to Thread
Results 1 to 1 of 1

Count working shift in start and end date

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    MALAYSIA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Count working shift in start and end date

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1