Conditional Formating for Time Sheet

A

Akash

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
 
A

Akash

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
 
P

p45cal

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/97964_ner6c/conditional-formatting.png
(I used different colours for testing)
 
A

Akash

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/97964_ner6c/conditional-formatting.png
(I used different colours for testing)

thanks a tonn.... and sorry tooo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top