+ Reply to Thread
Results 1 to 3 of 3

Time & Attendance x

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2003
    Posts
    14

    Time & Attendance x

    I have another time& attendance problem!
    This should be easyer cause the problem is from date format.
    Here are the 2 files - one that works
    and another one that doesnt work
    the data field seems the same
    (the one that works use the date format from colum V sheet 1)

    (the one that doesnt work use the date format from colum W sheet 1)

    how can i format the column w in order for me to get data result and no error?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-08-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Time & Attendance x

    forgot to mention - the results are in the sheet two

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Time & Attendance x

    Thank you all for not telling me what the problem is...this way i managed to put my brain to work...perhaps the solution was way to simple for you excel guru's to bother answering...

    For the less fortuned ones, this is the answer to my problem:
    use text to columns feature (select text as output) for year day and month ...and the just put this function to the result column =Date(year cell,month cell,day cell)
    Thank you all!

+ 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