Results 1 to 14 of 14

Using excel to manage worked houres !?

Threaded View

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

    Using excel to manage worked houres !?

    Hello!

    I'm using excel 2003 and I'm trying to make a excel staff file that would manage the time worked by employees. The data is exported from a acces sistem (the sistem just export in excell files the time when a worker entered and exit he does not calculate the total time spent). I've attached a excel file that with an example of what I want to do :

    - in the sheet "Data exported from acces sistem" I'll paste the results from the access sistem
    - in the sheet "Staff manager" I'll have just one table (the one who auto extracts the data from "Data exported from acces sistem" sheet); in the example I give you 2 tables first is where I want the formulas and the second is an example on who the first one should look like

    In my opinion the formula for IN time for a person should be something like: =IF( both NAME and DATE from "Staff manager" sheet are found in "Data exported from acces sistem" sheet ; GET MIN of the IN TIME for that DATE ; " " )

    This post is also open on mrexcel forum:
    http://www.mrexcel.com/forum/showthread.php?t=570300
    Attached Files Attached Files
    Last edited by alinpion; 08-10-2011 at 05:03 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