24-hour time stream insert times from working card automatically colored

Nikko

Board Regular
Joined
Nov 26, 2018
Messages
72
Hello everyone,

Come back to my favorite topic :)

Have a small VBA script built in that he automatically shows the entered working hours on the sheet "Januar" in the sheet "IND1" in the respective employee row.
For example, if I enter the time in Dienst 1" for "MA1" in sheet "Januar" from 12:00 to 15:00, all cells between 12:00 and 15:00 (include them too),
should appear in color on sheet "IND1" from 12:00 to 15:00 . the rest no color.
The same should happen for every "Dienst 1, 2 " and “Bereitschaft” in every "MA" (all 10 MA & GL) in sheet "IND1".

Notice: if MA have 3 diferent times Dienst in the same Day, must be only the time line in the Workingtime appear.
“MA1” haves “Dienst1”: “von 12:00 ‘”bis 15:00”, “Dienst 2” “von 16:00” “bis 19:00” and “Bereitschaft” “von 20:00” “bis 5:30” all working times write in sheer “Januar”,
must appear all this workingtimes in colour, rest cells no colour in the same row in sheet “IND1”

Workbook Link: VBA Timeline ala Gant VBA script

This VBA script is hanging somewhere. Has been made by a good person to help me, only for the next time he is prevented for personal reasons.

Any help is welcome ... need "a little" support.

PS. The VBA code should be so that I can copy it in the new sheets for each month.

Big Thanks in advance 🙏
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,122,976
Messages
5,599,139
Members
414,292
Latest member
kingshuk963

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top