# CUSTOMER ZONE

## How to track employees that are not entering a minimum of 8 hours during business days?

Customer is using P&B and wants to track employees that are not entering a minimum of 8 hours during business days. Setting up a validation rule is the best method but as the user does not have T&A we can create a report to capture that information:

1) Customized the Detailed Task Report
2) Enabled Entry Date,Total Hours and User Name fields
3) Created a custom column using the below formula

If((Day(EntryDate)
+floor((13*if(month(entrydate)>2,month(entrydate)-2,month(entrydate)+10)-1)/5)
+if(month(entrydate)>2,mod(year(entrydate),100),mod(year(entrydate),100)-1)
+if(month(entrydate)>2,floor((mod(year(entrydate),100)/4)),floor((mod(year(entrydate),100)-1)/4))
+floor(((year(entrydate)-mod(year(entrydate),100))/100/4))
-(2*(year(entrydate)-mod(year(entrydate),100))/100))
–
(7*floor((Day(EntryDate)
+floor((13*if(month(entrydate)>2,month(entrydate)-2,month(entrydate)+10)-1)/5)
+if(month(entrydate)>2,mod(year(entrydate),100),mod(year(entrydate),100)-1)
+if(month(entrydate)>2,floor((mod(year(entrydate),100)/4)),floor((mod(year(entrydate),100)-1)/4))
+floor(((year(entrydate)-mod(year(entrydate),100))/100/4))
-(2*(year(entrydate)-mod(year(entrydate),100))/100))/7))=0,"Weekend",If((Day(EntryDate)
+floor((13*if(month(entrydate)>2,month(entrydate)-2,month(entrydate)+10)-1)/5)
+if(month(entrydate)>2,mod(year(entrydate),100),mod(year(entrydate),100)-1)
+if(month(entrydate)>2,floor((mod(year(entrydate),100)/4)),floor((mod(year(entrydate),100)-1)/4))
+floor(((year(entrydate)-mod(year(entrydate),100))/100/4))
-(2*(year(entrydate)-mod(year(entrydate),100))/100))
–
(7*floor((Day(EntryDate)
+floor((13*if(month(entrydate)>2,month(entrydate)-2,month(entrydate)+10)-1)/5)
+if(month(entrydate)>2,mod(year(entrydate),100),mod(year(entrydate),100)-1)
+if(month(entrydate)>2,floor((mod(year(entrydate),100)/4)),floor((mod(year(entrydate),100)-1)/4))
+floor(((year(entrydate)-mod(year(entrydate),100))/100/4))
-(2*(year(entrydate)-mod(year(entrydate),100))/100))/7))=6,"Weekend",If((TotalHours<8),NumberToText(Abs(TotalHours-8))+" Hours Less","Met")))

This formula will show "Met" when employees have entered a minimum of 8 hrs on a day and will show "Weekend" if the time entry date is a weekend.

When the users fail to enter a minimum of 8 hours on their work days, then the column will display the hours less worked.