"Max" wrote:

Perhaps something like this ..

In B5:
=IF(B4="",0,VLOOKUP(B4,{"E",9.5;"G",9.5;"I",13;"J" ,12},2,0))
Copy B5 across to AE5

"",0,VLOOKUP there is some mistake ... excel gives me error for it.
Best for me would be that kind of formula that, when im doing new grapg
everymong different then just by typing for an example E then and the end of
line in working hours cell would appear 9,5hours, and when i keep adding
letters then the sum will growth