Results 1 to 14 of 14

Using excel to manage worked houres !?

Threaded View

  1. #4
    Registered User
    Join Date
    05-16-2011
    Location
    Bucharest
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Using excel to manage worked houres !?

    I've tryied to in modify the formula for night shift but it does not work

    =INDEX(MOD(dataexport!$I$2:$I$20;1);MATCH(1;(dataexport!$G$2:$G$20=$A3)*(INT(dataexport!$I$2:$I$20)=($B$1:$E$1));0))

    B1 has the today date 24/07/2011 and E1 tomorrow date 25/07/2011 by having the extra date I can manage the night shifts.

    For OUT time I need the formula to compare the date from today and the date from tomorrow with the date from data export
    Last edited by alinpion; 08-10-2011 at 07:28 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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