Hello! I'm looking for help on an excel sheet that I'm creating to currently track my time at work, eventually providing to my coworkers to use to track their time. In my workplace, we have a time entry system that registers minutes on a job number in 0.25 increments of an hour (0.25 = 15 minutes). The purpose of this sheet is that an associate could enter a job number into e.g. column B and amount of time in column C on a particular row (3-45) depending on when the work for that job was conducted e.g., if you worked on job #35818 on April 27th from 10:00 to 10:45, you would put 35818 in cell B15 and the time 0.75 in cell C15.
The output is a list in rows 49-72 of all the unique job numbers entered in rows 3-46 of the same column, with the column next to each totaling the time for that job number. This allows for easy entry as sums up all time spent by job number in a day.
Now what I'm looking to do is in cells 3-46, I want to conditional format based on values in the time column per day: if 0.25 was entered in any given row, nothing would happen since rows are treated as 15 minute increments. but if 0.5 was entered, it would conditional format the cell below to be darker showing that the row above is taking two of the 15 minute increment rows. if it were 0.75, the two cells below would be formatted. If it were 1 the three cells below would be formatted. I also need the formatting to be either draggable or cell references update when using the format painter.
I've attached the file that I'm working in, hopefully it'll help relay what I'm trying to do here
Appreciate the help!!
Bookmarks