Thanks so much for your response. I feel like I should be able to use the formulas you created and apply them to my schedule, but I'm still having some trouble. What do the dates ranging from A10:A57 represent? I think I understand how you calculated hours earned, but I have no idea how you calculated hours used. I would think that hours used would be an input value you'd have to manually insert as an employee used time. If you have time to clarify I would greatly appreciate it; if not, now worries, I'll keep playing with it and hopefully stumble on the solutions. Thank you again.