I do not understand the logic for hours assignment.
There're 13 not 5 hours between "0600" and "1900".
Also what is the meaning of 'user works betw "0600" and "1900"' ?


>
>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