View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
diydan48 diydan48 is offline
external usenet poster
 
Posts: 1
Default 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.