>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?
If it's not broken, fix it until it is.
My Blog