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

Nikko

Board Regular
Joined
Nov 26, 2018
Messages
73
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 ?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,008
Messages
5,834,852
Members
430,324
Latest member
bosphoruskid

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