I am trying to create a formula in a virtual column for Vacation hours used, vacation hours remaining.
My main Employee sheet has their vacation hour allocation for the year. I have a time off able that records vacation hours requested and based on the code, allocates hours.
So basically I need to sum records based on the employees email and subtract from the allocated time.
In short, if John has used 16 hours and gets 80 hours, it would display 16 used and 64 remain,
Thinking I need virtual columns in the employee table but then drawing a blank.