ABC Missing Time Cards
Say you have employee contacts and they are supposed to submit time cards of their activities each week. You need to know when someone has missed a time card or if someone has not logged their time. How can you measure this if they havenât done it? The answer resides in knowing what should be there and measuring if it isnât. In this example we need to know the window of time that we are interested and calculate the number of weeks we expect time cards. We start with a start date and compare it to today. We take the start date and calculate the first day of the week and then we take todayâs date and calculate the last day of this week so we get a spread of days and add 1. Then we can divide by a 7-day week to get the number of weeks for which we need time cards.
Be the first to review this app!
Browse popular apps
Explore related apps
Try Quick Base Today
30 day free trial. No credit card required.Get Started