+ Reply to Thread
Results 1 to 14 of 14

Using excel to manage worked houres !?

Hybrid View

alinpion Using excel to manage worked... 08-10-2011, 05:01 AM
Bob Phillips Re: Using excel to manage... 08-10-2011, 05:23 AM
alinpion Re: Using excel to manage... 08-10-2011, 06:16 AM
alinpion Re: Using excel to manage... 08-10-2011, 07:07 AM
Bob Phillips Re: Using excel to manage... 08-10-2011, 07:34 AM
alinpion Re: Using excel to manage... 08-10-2011, 07:49 AM
Bob Phillips Re: Using excel to manage... 08-10-2011, 08:38 AM
alinpion Re: Using excel to manage... 08-10-2011, 09:11 AM
alinpion Re: Using excel to manage... 08-11-2011, 04:25 AM
Bob Phillips Re: Using excel to manage... 08-11-2011, 04:27 AM
alinpion Re: Using excel to manage... 08-11-2011, 04:53 AM
Bob Phillips Re: Using excel to manage... 08-11-2011, 05:27 AM
alinpion Re: Using excel to manage... 08-11-2011, 05:49 AM
akmsikhan Re: Using excel to manage... 10-18-2011, 03:30 PM
  1. #1
    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.

+ Reply to Thread

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