Conditional Formatting vs Time Formula

[whitehead6682]

Hi All

I'm trying to work out if orders are being planned and moved on time.

Ideally, using conditional formatting to highlight ifb the target was acheived or not.

However, I'm having a issue again with the time period falling into day 2.

Example.

Target Time = 20:30 , Acual Time = 00:21, this should equal "L" and Red, however I can't seem to get it that way.

Any help is appreciated

Regards

Chris...

[TMS]

I can't see how you'd do this without including the date in the target time. You could calculate the actual time from the header for the column plus the time in the row. Otherwise, it's just going to assume that actual time less than target time = good.


Regards