CUSTOMER ZONE
How to track employees that are not entering a minimum of 8 hours during business days?
Find resources designed to help you get the most from Replicon
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.