Answered You can hire a professional tutor to get the answer.
The formula I'm using is to see where the clock in and clock out time land in the 30 min increments.
i need help with different excel formula. The formula I'm using is to see where the clock in and clock out time land in the 30 min increments. but it doesn't work less then 30 min or if is goes from 11pm till 2am.