+ Reply to Thread
Results 1 to 2 of 2

Combaning info/tables from two different timetables to one worksheet

  1. #1
    Registered User
    Join Date
    09-06-2020
    Location
    Estland
    MS-Off Ver
    2016
    Posts
    1

    Combaning info/tables from two different timetables to one worksheet

    Hey!

    For starters - english is not my language (actually fourth) so trying to formulate the problem is task his own - please bear with me - thanks

    First - task is to create a work schedule for a small store - around 6-10 persons. As the "taxman" buts up some regulation did not find a ready solutions.
    Did find 2 worksheets that have info needed to collect but better one (attached workbook sheet1) missing some statistical info.

    So I need to add cell that show over worked time and not enough worked time - other workbook (in attached sheet2) has that properly coded cells
    (marked between red lines) but after few days trying have not able to transport those cells to first book.

    Second - is it possible to put calendar on that workbook - so it makes sundays and marked holidays (non working days) automatically red?

    I have some hands one experience on excel but seems not enough - any help is appreciated - thanks again.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,570

    Re: Combaning info/tables from two different timetables to one worksheet

    Hello Matikas and Welcome to Excel Forum.
    I find that the online translators are pretty accurate and you can copy from the English translation side and paste to the Quick Reply window.
    As for marking Sundays, the values in row 2 are converted to dates. Cell C2 contains the first day of the month (manually entered) and the rest of the dates fill by formula: =IF(C2< EOMONTH($C2,0),SUM(C2,1),"")
    The conditional formatting is: =WEEKDAY(C$2)=1
    Looking at Sheet2 the normal number of hours to be worked in a month seems to be manually entered as in cell AH1.
    The values in column AH are now calculated using: =IF(OR(LEFT(B4,4)="Team",B4=""),"",SUMIFS(AL4:BP4,AL$2:BP$2,">="&C$2,AL$2:BP$2,"<="&EOMONTH(C$2,0)))
    Normal hours worked is displayed using: =IF(OR(LEFT(B4,4)="Team",B4=""),"",MIN(AH4,AH$1))
    Overtime hours are calculated using: =IF(OR(LEFT(B4,4)="Team",B4=""),"",AH4-AI4)
    Not enough time (Under Time) hours are calculated using: =IF(OR(LEFT(B4,4)="Team",B4=""),"",AH$1-AH4)
    I would need to know the absence codes to help there.
    The "differ" column on Sheet2 references another file, so I don't know how to help with that.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 10-02-2013, 03:00 PM
  2. Macro to create tables ang graphs from info on worksheet
    By TERRI LEE in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2013, 04:19 AM
  3. Show info on one worksheet, depending on info from another worksheet
    By kcrowe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-26-2012, 12:21 PM
  4. Can a macro change data on tabs when info in F7 of Job Info worksheet changes? If so How?
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-05-2012, 02:59 AM
  5. Search and find info, if correct info found copy into new worksheet
    By JnrParki in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2011, 11:36 AM
  6. TimeTables
    By Bruiser in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-19-2006, 11:25 PM
  7. Tables, How do I make new info push existing info to the next row?
    By PeteL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2006, 04:50 PM
  8. WHAT TYPE OF TIMETABLES ARE THERE
    By Technician timetable in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2005, 06:06 AM

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