Keep your hair on Akash..
In column C, cell C2, conditional formatting for Condition 1:
Formula is: =AND(B2<TIME(20,29,0),C2>TIME(9,30,0))
Condition 2 in C2 is:
Formula is: =AND(B2>=TIME(20,29,0),C2>TIME(10,30,0))
For column B , cell B2 conditional formatting is:
Cell Value is | Greater Than | 0.853472222222222
Copy the conditional formatting using the format painter to other cells in
the columns.
All cells are formatted as Time.
Picture available here:
http://www.hotlinkfiles.com/files/97...formatting.png
(I used different colours for testing)
--
p45cal
"Akash" wrote:
> On Jun 27, 10:02 am, Akash <maheshwari.ak...@gmail.com> wrote:
> > Hi,
> >
> > What would be the conditional Formating in the column B & C
> >
> > A B C
> > Time In | Time Out | Time In
> > 9:30AM | 8:25 PM | 9:31 AM
> >
> > Members working late after 20:30hrs will be given the permission to
> > come to work the next day by 10:30hrs.
> >
> > So in Column B i have placed only one condition that if the employee
> > works after 20:30hrs make the font bold otherwise regular fonts.
> >
> > In Column C what would be the conditional formating.
> >
> > Our company policy is:
> >
> > If worked till 20:29hrs then the employee is allowed to resume his
> > work by 9:30hrs next day, if after 9:30hrs it should be Red in color.
> >
> > if worked till 20:30hrs then the employee is allowed to resume his
> > work by 10:30hrs next day. if after 10:30hrs it should be red in
> > color.
> >
> > How to put the conditional formating in the Column "C"
> >
> > Awaiting for your response.
> >
> > Thanks
> >
> > Akash Maheshwari
>
> Awaiting for the resolution. Kindly helm me in this regards....
>
> Thanks
>
> Akash
>
>
Similar Threads
