Hello! I need to create a formula that will calculate 1 hour of sick time for every 30 hours that the employee worked, with a running total. So in the spreadsheet that I provided it would be Total Hours/30. They have an annual maximum of 56.00 hours per year, but I can do that manually. As always, thank you very much, you guys have been invaluable helping me!