I have a spreadsheet that is a 2 week schedule of time.
If the cell is blank - the employee worked
if the cell is filled - the employee took the day off by burning leave or sick time
my problem is how can I set it up so that I can enter a total into the cell with a designation (like L for leave and S for sick, thus given an in cell value of 8L for 8 hours of leave) and have the spreadsheet count up all of the values with L and all of the values with S and display the totals in the "leave balance" and "Sick Balance" Columns?
Thanks
If the cell is blank - the employee worked
if the cell is filled - the employee took the day off by burning leave or sick time
my problem is how can I set it up so that I can enter a total into the cell with a designation (like L for leave and S for sick, thus given an in cell value of 8L for 8 hours of leave) and have the spreadsheet count up all of the values with L and all of the values with S and display the totals in the "leave balance" and "Sick Balance" Columns?
Thanks