G
guilbj2
I have one cell with a sum of time reduced by allowing staff to leav
early on days where we're slow. I'm using the custom format [h]:mm.
All I want to do is divide that number by 37.5 hours and I'm having
fair bit of trouble. Any pointers on what formula and/or syntax
should be using? I've tried simply doing =A1/37.5 but the result I'
getting back is not correct.
I'm looking to have the result represented as a number w/ 2 decima
places to indicate the FTE (Full Time Equivalent = 37.5 hours per week
we've saved
early on days where we're slow. I'm using the custom format [h]:mm.
All I want to do is divide that number by 37.5 hours and I'm having
fair bit of trouble. Any pointers on what formula and/or syntax
should be using? I've tried simply doing =A1/37.5 but the result I'
getting back is not correct.
I'm looking to have the result represented as a number w/ 2 decima
places to indicate the FTE (Full Time Equivalent = 37.5 hours per week
we've saved