J
JEB
I need some help. I am trying to build a simple vacation tracker for the
office. I have built a small calender with each cell as one day in the year.
For each employee I am entering a "V" for when they take a vacation. I have
used the "count" funtion, which works great if the employee schedules a full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.
office. I have built a small calender with each cell as one day in the year.
For each employee I am entering a "V" for when they take a vacation. I have
used the "count" funtion, which works great if the employee schedules a full
day of vacation. If I need ".5V" for a half day of vacation, I cannot add
this to my count for the number of days taken by the employee. Is there some
function I can use to add up all of the "V" and ".5V" for the month to see
the vacation time taken.