Hey guys, can someone help me with this. What I wanted to know is what formula to use to calculate the late/tardy HOURS per 30 minute interval instead of just FTE.
So I have a rawdata where I am putting the names with start and end time for their lates/tardiness. Then there is another tab where I put all the intervals for the day (30 minute increment) and just manually calculate the late hours to their corresponding intervals. The goal is to generate a formula to calculate these late hours and show exactly the same result with just manual calculations.
Bookmarks