The visual I was thinking was one where I see all the times in a day listed and highlights the NULL records with a red color and rest with green confirming  based on a status field that has "Yes" and "NULL" values.

Thanks

How do I also ensure for any new null records the color red is retained...since I find all other colors in the palette to be used for coloring new data in the bar chart. I want only red for NULL and green for processed records.

Aditionally I was thinking of orange for records that are to be processed in a day. This will happen since the time for the process is yet to be crossed. Ex: The process is to be intiated at 5:00 PM the current time is 4:45 PM. The chart will show these in Orange color and once processed as green.

So the Column for status will have another flag "P" apart from Yes and NULL that will be used to color orange to the P records(records to be processed)

Have updated the question to reflect the same

Thanks in Advance for helping me out

When I use the calculated field with my data it says

Can't add Datetime and string values. I have also tried to type convert,but nothing works.

The field for Time in my case in the database is a varchar(10) field in SQL database.

Please help...I am only not able to create the calculated field

Thanks in Advance

Hi Alex,

Can you please help date is of this format :

11/7/2012 12:00:00 AM

It shows null values on using the formulae