NOTE: This post is now obsolete, as I have released Version 4.0 of the Workbook and the formula has been corrected in that version.
Jeff Phillips noticed on a recent deployment that, somehow, the hours were not calculating properly in the total FTE box. I’m not sure why it doesn’t work that way anymore but I managed to fix it on the fly.
I will be releasing a new version this week, as I have added a staff availability calendar to the template. In the meantime, though, Caz Milligan used the workbook template for EQNZ last night and had the same problem, so here is the updated formula for the Check In/Out sheet, cell H3. Copy this formula, paste into cell H3, and hit Enter/Return on your keyboard and that should fix it. If not, please leave a comment and I’ll see what’s going on: