storing lettrs in an excel cell to later = a number for a formula
in cell b3 I want to store the letter H to indicate a holiday has been taken.
I then need the total column at the end of the week to be able to look at the
H and use it as 7.5. Indicating that 7.5hrs of holiday has been used.
|