Wanted to see if those smarter than me have an idea, and wanted to brainstorm.

i’m making a spreadsheet that can help users visualize how much leave they have in days & weeks.

IE 16 hours of annual leave, calculates 8h shift = 2 days.

weekly just divide by 40 hours.

issue comes in when co-workers who are doing 9h shifts. 

How it works in our organization

week 1: Mon-Thurs 9h shift. Friday 8h shift

week 2 :Mon-thurs 9h shift, Friday off.

This way in a pay period it is still 80 hours.

Trying to figure out a formula for calculating days. Part of me was thinking about doing elementary school math.

divide by 9, any remainder divide by 8, and add them together. ty

​Wanted to see if those smarter than me have an idea, and wanted to brainstorm. i’m making a spreadsheet that can help users visualize how much leave they have in days & weeks.IE 16 hours of annual leave, calculates 8h shift = 2 days.weekly just divide by 40 hours. issue comes in when co-workers who are doing 9h shifts. How it works in our organizationweek 1: Mon-Thurs 9h shift. Friday 8h shiftweek 2 :Mon-thurs 9h shift, Friday off.This way in a pay period it is still 80 hours. Trying to figure out a formula for calculating days. Part of me was thinking about doing elementary school math.divide by 9, any remainder divide by 8, and add them together. ty  Read More

​