hi naomi,

please naomi see message to sergey...



>>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
>
>How did you get 5 and 1 for 1st and last record?