Shift Calendar Shading

[brucey2343]

Hey guys,

I am creating a shift calendar for my varied work schedule and I want to select a site I am working on using data validation, then have the appropriate amount of cells shaded to show the hours worked. For example: Monday 7am-7pm is cells I3:U3. If I select a site that is 12 hours and that timeframe, I would like excel to automatically shade them in a chosen colour, calculate my total gross profit and distance travelled to the site and back, among other details.

Any help would be greatly appreciated.

Anthony

P.s. I would like to use vlookup to do the calculations for me. Thank you

[brucey2343]

and for it to take the start and finish times and automatically shade the correct cells

[rajeshturaha]

Try using this formula in CF

Please Login or Register  to view this content.

Plz see the attachment

[brucey2343]

and if I wanted to use it on a different workbook, how would I adjust the formula? could you explain all of the references in formula please

[brucey2343]

I want to take information from a different sheet to see which site im working on and what times, then shade the calendar accordingly

[rajeshturaha]

Formulas in CF dont fetch data from another sheet or workbook, instead u can use name range to define the start time and end time