HomeCustomer ZoneSupportHow 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.