Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import all hours over 10 (Excel 2003)

    hello all,
    i have a question about copying/importing all times greater than 10 hours (10:00) from all worksheets in all workbooks in a folder
    in M1 in every worksheet stands the name of the employee and from a5:a35 every day of the month and in f5:f35 the worktime from every day.
    what i need is a copy of the name of the employee , the date and the hours > 10:00 imported into one consolidated sheet.
    help would be appreciated,
    stefan

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: import all hours over 10 (Excel 2003)

    Check out <post:=714,919>post 714,919</post:> for a similar request.

    It will have to be modified for your specifics. [Let us know if you need help with some of the details]

    [One question that will eventually come up is the "10 hrs" the number 10 or is adjusted to display "10:00" with a number format. If it is the latter you will be searching for a number > 10/24 since XL's date/time functions work in units of days not hours.]

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Feb 2007
    Location
    Vienna, Wien, Austria
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: import all hours over 10 (Excel 2003)

    thanks for your reply, i tried the attached code.
    its a quick and dirty solution, it imports all data of all worksheets,
    so i can eliminate all the hours < 10 in a 2nd routine....
    stefan
    Attached Files Attached Files

Posting Permissions

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