Hello All,
i'm trying to write a formula that combines name, leave type, and amount of hours all separated by a dash in a calendar that then references their remaining balance on the main page and substracts the amount of hours. Please see below the screen shots of what i am talking about and trying to perform. Any help would be greatly appreciated.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
i'm trying to write a formula that combines name, leave type, and amount of hours all separated by a dash in a calendar that then references their remaining balance on the main page and substracts the amount of hours. Please see below the screen shots of what i am talking about and trying to perform. Any help would be greatly appreciated.
| Back to EE's</SPAN> | ~ January 2014 ~</SPAN> | Feb 2014>></SPAN> | |||||||||||
| Sunday</SPAN> | Monday</SPAN> | Tuesday</SPAN> | Wednesday</SPAN> | Thursday</SPAN> | Friday</SPAN> | Saturday</SPAN> | |||||||
| 1</SPAN> | New Year's Day</SPAN> | 2</SPAN> | 3</SPAN> | 4</SPAN> | |||||||||
| 5</SPAN> | 6</SPAN> | 7</SPAN> | 8</SPAN> | 9</SPAN> | 10</SPAN> | 11</SPAN> | |||||||
| Christa - Vac - 4</SPAN> | |||||||||||||
| 12</SPAN> | 13</SPAN> | 14</SPAN> | 15</SPAN> | 16</SPAN> | 17</SPAN> | 18</SPAN> | |||||||
| Christa - Vac - 8</SPAN> | Christa - Vac - 8</SPAN> | Christa - Vac - 8</SPAN> | Christa - Vac - 8</SPAN> | Hannah - Vac - 8</SPAN> | |||||||||
| Christa - Vac - 8</SPAN> | |||||||||||||
| 19</SPAN> | 20</SPAN> | Martin Luther King</SPAN> | 21</SPAN> | 22</SPAN> | 23</SPAN> | 24</SPAN> | 25</SPAN> | ||||||
| Jane - Per - 8</SPAN> | |||||||||||||
| 26</SPAN> | 27</SPAN> | 28</SPAN> | 29</SPAN> | 30</SPAN> | 31</SPAN> | Notes:</SPAN> | |||||||
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>
| Name</SPAN> | LV Type</SPAN> | Balance</SPAN> | Taken</SPAN> | Remaining</SPAN> |
| Kristine</SPAN> | Vac</SPAN> | 200</SPAN> | 200</SPAN> | |
| Kristine</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Hannah</SPAN> | Vac</SPAN> | 80</SPAN> | 24</SPAN> | 56</SPAN> |
| Hannah</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Jane</SPAN> | Vac</SPAN> | 120</SPAN> | 120</SPAN> | 0</SPAN> |
| Jane</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | 0</SPAN> |
| Deloris</SPAN> | Vac</SPAN> | 160</SPAN> | 24</SPAN> | 136</SPAN> |
| Deloris</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Deb</SPAN> | Vac</SPAN> | 120</SPAN> | 120</SPAN> | |
| Deb</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Corien</SPAN> | Vac</SPAN> | 120</SPAN> | 120</SPAN> | |
| Corien</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Christa</SPAN> | Vac</SPAN> | 120</SPAN> | 120</SPAN> | |
| Christa</SPAN> | Per</SPAN> | 16</SPAN> | 16</SPAN> | |
| Megan</SPAN> | Vac</SPAN> | 120</SPAN> | 12</SPAN> | 108</SPAN> |
| Megan</SPAN> | Per</SPAN> | 16</SPAN> | 16 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL></COLGROUP>
