Conditional Formating based on time.

[Reid]

I'm trying to make a layout that shows today's hours that have been reported by an employee. Basically a horizontal graph that shows 6:00am on the left and 6:00pm on the right. For each hour that has been reported I want it to "fill in" those hours on the graph.

Hours are reported in another layout. One entry could be that they worked from 6:00am to 9:00am.

In order to get the graph to "fill in" I'm thinking of having Conditional Formating based on a formula that finds out if there has been anything reported for that time slot. I'm planning on having a conditional formating area for every 15 min block.

So for my block designated for 6:15am - 6:30am could I have a formula that says IF timereported > 6:15am < 6:30am then fill in red would that work?

Is there a better way to go about this?

Sorry, this should probably be in the conditional formatting forum. How do I move it?

Edited December 2, 2010 by Guest
Wrong forum

[comment]

I believe a repeating calculation field would make this easier.

[Reid]

I've never used a repeating calculation field. Can you give me a jist of how it would work? I'll study up on repeating calculation fields in general.

[comment]

Roughly:

Let each repetition calculate its slot start and end times, using Get ( CalculationRepetitionNumber ). Return true if the slot overlaps with worked time.