Miscalcuation on vacation hours

Grrrrr, I received my Earnings Statement aka pay stub and I miscalculated my vacation hours. Remember I took a vacation day earlier this week? I should have taken it last week. I ended up losing around 4 hours. That's half a day I could have used to play. I've redone my spread sheet so hopefully this won't happen again.