Automatically change color of timesheet lines depending on working hours

[jujuby]

Hello,

I am doing weekly timesheets for my employees and I am looking for a macro that could help me easily highlight the working hours of my team throughout the day. In the excel doc I linked I tried to show you what I would like to achieve automatically, while I have to do it manually at the moment. I would like the color of the cells in my table to change depending on when people work. For example if my Employee 1 works from 9.30AM to 6PM I would like the line of this employee between that timeframe to be colored in Green.

It is very complex and I am not sure that it is feasible with the current design of my sheet, I have tried many different formulas through Conditional Formatting but I have 2 values to consider which are the starting and the ending time and I think the only option would be to use a macro but I have no idea how to code it. I am stuck here, maybe it is impossible .

If anyone have a clue I thank you in advance for your lights!

Jujuby

[Eastw00d]

Hi Jujuby,
welcome to the forum.
you can easily solve this with formulae, in the area where you put your conditional formatting:

Please Login or Register  to view this content.

Cheers
Erwin

[jujuby]

Thank you so much that's exactly what I need
It is possible to extend the formula to include breaks where the color of the cells will stay blank?

Th k you again for your help Erwin, really appreciate!

Hi Jujuby,
welcome to the forum.
you can easily solve this with formulae, in the area where you put your conditional formatting:

Please Login or Register  to view this content.

Cheers
Erwin

[Eastw00d]

Yes, but you did not specify when the breaks starts (that could be different at each row, at least that was in my company), I suggest that you add an extra column for that, in between, and then you can apply this one:

Please Login or Register  to view this content.

cheers
Erwin