hi all,

i have a table with this structure

cname C(8)
cbeginning c(4)
cend C(4)
nhours100 n(5,2)
nhours120 n(5,2)
nhours135 n(5,2)
nhours150 n(5,2)
eg
cname = "Isnight"
cbeginning ="1400" for beginning of team work
cend C(4) = "2300" for end of team work

if user works betw "0600" and "1900" here i want nhours100 = 5
if user works betw "1900" and "2000" here i want nhours120 = 1
if user works betw "2000" and "2200" here i want nhours135 = 2
if user works betw "2200" and "0600" here i want nhours150 = 1

which formula can i use ?

thank in advance

bernhart