Hi, I would like to know if the employees are arriving at the agreed time, including the tolerance and if they are not, how many minutes of delay they are arriving and also to know if the late ones have compensated for this delay in the day or in the entire period. How to do this?
In D7 and copy down =IF(ROUND(B7,3)-ROUND(INT(B7),3)>=ROUND($D$3,4),"Late","On Time")
In E7 and copy down =IF(ROUND(C7,3)-ROUND(INT(C7),3)>=ROUND($D$2,4),"OK","Early")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks