Microsoft Excel - Need a spreadsheet to track accured PTO hrs where every 30 hours=1 hr of accrued time/wk

As of July, Massachusetts employers have to track PTO where for every 30 hours of work/week, the employee earns 1 hour of PTO (paid time off).  Is there a formula that can calculate this?  Ideally I would enter the number of hours each week and there would be a total at the end that would calculate hours earned.  Thanks for any help!!

I don't have a formula for you but I would add that your formula would need to take into account PTO taken along with other days (holidays etc...) for a given year that wouldn't count towards the 30 hours.  Just think this might be more complicated than a simple formula as each year would present different calendar obstacles and complications.

Hello Kristine,
Without knowing exactly your data layout and time span to be covered it is a bit hard to be helpful but if your data is contiguous in the same row and the later cells are empty or zero then a formula like =SUM(Bxx:Zxx)/30 would be one place to start but as Robbe says, if you need to account for time taken and other factors then the situation becomes a bit more complicated.
Regards
Harry

Hello again Kristine,
If you have to only accumulate the time in lieu if the hours for a given week are more than 30 the if the data is laid out

Day1, day2, day3,etc, Week total, Day1,day2,day3,etc,Week total etc

then the following formula would work.

=SUMPRODUCT(((Bxx:Zxx)>=30),Bxx:Zxx)/30 would give you a result.

As I said before what you might want could end up being quite complicated.

Harry

Thank you!  That works ;)