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
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