Hi. I am trying to figure out how to sum various daily time entries for a week into seven categories. My guess is that I must first designated each entry with a code, say 1 to 7 for each time category. I am having trouble figuring out the formula to sum the numerous daily entires into one of each of the seven categories. In the end, the sum of the seven categories would equal the sum of the daily time entries for the entire work week. Thanks.