count hours worked in a specific timeframe
Posted on 2011-09-26
i have a worksheet where i enter the hours worked. the start time is entered in the odd columns (C, E, G, I, K, M, O) and the end times entered in the even ones (D, F, H, J, L, N, P). our facility is operated in an unusual way. two organizations manage - in defined times. in order to bill the other organization, i need to be able to count all the hours each employee has worked during the week. the other organization operates from 3P to 10P. so, if an employee works from 2P to 8P, i need a formula that will return the value 5.